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

86 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
castrating134977(None) 
caseating12311742cas_eating
castigating1546002castigating
castrati1048642castrati__
castration12410802castration
castrations13410052castrations
lustrating1147782lustrating
abstracting1645183abstracting
acierating1348313acierating
actuating1239223_actuating
aerating92821003_a_erating
asperating1349563_asperating
aspirating1348363_aspirating
astatine8313533_ast_atine
astricting1357833_astricting
attracting1346563_attracting
attriting1048683_attriting
calibrating1645343calibrating
canulating1349543canulating
captivating1944883captivating
carting104228283ca__r_ting
cascading1545673cas_cading
casketing1635383cas_keting
casting104628343cas___ting
castling11311233cast__ling
castrate10313863castrat__e
castrated1239513castrat_ed
castrater1148523castrat_er
castraters1246473castraters
castrates11312673castrat_es
castrato1048523castrat__o
castrator1147643castrat_or
castrators1247443castrators
castratory1545143castratory
castratos1147633castrat_os
catenating1348683catenating
catfacing1744553ca_tfacing
catting103922643ca_t__ting
caveating1539293ca_veating
cavitating1646903cavitating
cavorting1536063cavor_ting
contracting16610473contracting
contrasting1459353contrasting
costarring1345393costarring
crating103725203c___rating
curating11314293c__urating
disrating11714553dis_rating
distracting1569253distracting
estating92614993_est_ating
estraying1338293_estraying
estreating11710363_estreating
filtrating1445973filtrating
frustrating1544263frustrating
gastrulating1482993gastrulating
gestating11229983gest_ating
instating10812213inst_ating
lacerating1349443lacerating
lactating1239183lact_ating
macerating1549533macerating
maltreating1455513maltreating
masticating1647833masticating
masturbating1772673masturbating
maturating13108573maturating
misrating121014853mis_rating
mistracing1569603mistracing
mistreating1449283mistreating
narrating10310353na_rrating
nitrating10312673_nitrating
outrating10916403_outrating
patriating13510203pa_triating
postdating1447163postdating
postmating1548603postmating
prostrating1449393prostrating
restarting11310663restarting
restating102319413rest_ating
satiating10311803sa_tiating
saturating11119203saturating
starting93116173__starting
stating83725163__st_ating
strafing122111193__strafing
strawing122411623__strawing
straying122912693__straying
striating10914193__striating
titrating10310113_titrating
unstating10711213unst_ating
upstarting1343883upstarting

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.420425454.8
2DLD Change Limit140603866.30022317.9
3Display Results86860.0461869.6
 (SQL Overall)178691866.76626410.1
 
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.