Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “busgirl” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
busgirl104414(None) 
busgirls1142651busgirls
batgirl1043392batgirl
aswirl935093_aswirl
basil75122273bas_i_l
batgirls1142403batgirls
begird1036823b_egird
begirt9412683b_egirt
bestial9311643bestial
bestir8311163bestir_
bestirs9311133bestirs
birl65830473b___irl
bluegill1142953bluegill
budger104617703budger_
budgers114314923budgers
budgie104310343budgi_e
budgies115312513budgies
budging124313023budging
bugger104418723bugger_
buggers114315663buggers
buggery14367933buggery
buggier113611343buggier
buggies114613813buggies
bugging123515183bugging
bulbil10389573bulbi_l
bulger94917353bulger_
bulgers105215143bulgers
bulgier103911213bulgier
bulging113514213bulging
bulgur9387533bulgur_
bulgurs10397113bulgurs
bunging113616503bunging
burger94020793burger_
burgers103918573burgers
burghal1335073burghal
burial84117623bu_rial
burl64937183bu___rl
busbar1038453busbar_
busbars1138153busbars
busbies113011693busbies
bushel114513943bus_hel
busher114922203busher_
bushers124018803bushers
bushfire1642603bushfire
bushido1344453bushido
bushier123712813bushier
bushily15268893bushily
bushing134018583bushing
busied95117223bus_ied
busier85219723bus_ier
busies85525263bus_ies
busily112211503bus_ily
busing96420593bus_ing
busker125517833busker_
buskers133414093buskers
buskin123811493buski_n
busking144116573busking
buskins133310943buskins
bussing103614623bussing
bustard10389723bustard
buster84726493buster_
busters94724133busters
bustic101012693busti_c
bustics11810883bustics
bustier93916153bustier
bustiers103810053bustiers
busting104221793busting
busying134211993busying
cowgirl1353273cowgirl
fusil84715323fus_i_l
girl56226553___girl
newsgirl1251823newsgirl
skirl96012913__skirl
suspire937803suspire
swirl84514143__swirl
ungird887973_ungird
ungirt71112713_ungirt
upgird10103933_upgird
upgirt9117263_upgirt

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.1561145455.1
2DLD Change Limit134027795.82623005.0
3Display Results79790.0164937.5
 (SQL Overall)178691795.99829791.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.