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

47 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
curtailing134460(None) 
curtaining1345531curtaining
airmailing1343633airmailing
bobtailing1543513bobtailing
brailing113514793_br_ailing
captaining1546073captaining
cocktailing2052783cocktailing
containing13410933containing
corralling1345433corralling
craaling112711353c_r_aaling
cradling122411453c_r_adling
crawling143110513c_r_awling
cuittling1234103cuit_tling
curarizing2247103curarizing
curating11314293cur_a_ting
curdling12228893cur__dling
curling104320183cur___ling
curtail9299663curtail___
curtailed1244113curtail_ed
curtailer1143823curtail_er
curtailers1243403curtailers
curtailment1552393curtailment
curtails10318243curtail__s
curtain9319793curta__in_
curtains10259703curta__ins
curtseying1641983curtseying
curtsying1543813curt_sying
cuttling1138203cu_t_tling
derailing112011313der_ailing
detailing112510413_detailing
entailing1039393_entailing
hurtling12318313hurt__ling
outraising1139903outraising
outsailing1137563outsailing
outwiling1337463ou_twiling
pertaining1347993pertaining
quailing1838403qu__ailing
railing83325643__r_ailing
retailing103214733_retailing
surtaxing1784143surta_xing
sustaining1145883sustaining
tailing82923103___tailing
trailing92916093_tr_ailing
turmoiling1343223turmoiling
turtling9238833turt__ling
unfailing1337453_unfailing
unnailing1037023_unnailing

Search took 8 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.470380193.6
2DLD Change Limit140603477.14019692.3
3Display Results47470.0162937.5
 (SQL Overall)178691477.62623431.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.