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 “wrestlings” 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.

61 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
wrestlings144293(None) 
wrestling1336061wrestling_
crestings12298042crest_ings
nestlings1074312_nestlings
restrings10159292_restrings
westings12429802w_est_ings
whistlings1742912whistlings
wrastling1335522wrastling_
wresting123811832wrest_ing_
beestings12335923beest_ings
biestings12266033biest_ings
breathings16234313breathings
brislings12236363bris_lings
bristling1246663bristling_
cresting114017043crest_ing_
dieselings1252933dieselings
dressings11265373dres_sings
eyestrings1462773eyestrings
fettlings1353753_fettlings
firstlings1442523firstlings
frostings1335733frost_ings
frostlines1345193frostlines
greenlings1243593greenlings
greetings11276043greet_ings
jestings16368023_jest_ings
nestling958893_nestling_
pestling111010253_pestling_
pressings12269023pres_sings
rattlings10235513_rattlings
reedlings11236343_reedlings
reelings94012563_re_elings
resiling93520173_resiling_
resilins83013373_resilin_s
resittings11264553_resittings
resoling92916303_resoling_
resprings12156253_resprings
resting85031183_rest_ing_
restring91518783_restring_
restyling1337923_restyling_
rieslings1034493ries_lings
rustling9249983_rustling_
settlings1054683_settlings
vestings12359143_vest_ings
waistings1352710763waist_ings
waistlines1343893waistlines
warstling1335063warstling_
weaklings1794003w_eaklings
weanlings1394413w_eanlings
weltings12388203w_elt_ings
westing115020273w_est_ing_
wettings12348403w_e_ttings
wheelings16284933whe_elings
whistling1644733whistling_
whittlings1742223whittlings
witlings12328443w__itlings
wrassling1334273wrassling_
wreathing16266313wreathing_
wreckings19233683wre_ckings
wrestlers12306103wrestl_ers
wrestles113310063wrestl__es
writings12298113wr_it_ings

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 Filter1786911406030.410435831.7
2DLD Change Limit140603616.01323383.2
3Display Results61610.0163812.5
 (SQL Overall)178691616.43927751.4
 
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.