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 “defecated” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
defecated163749(None) 
defeated132812161defe_ated
defecate1438791defecate_
defecates1538591defecates
defected15289971defec_ted
deaerated11311112deaerated
dedicated14310252dedicated
defalcated1744182defalcated
defeater122611662defe_ater
defecator1546382defecator
deflated133412302def_lated
deflected1635982deflec_ted
dejected19307592dejec_ted
delectated1446722delectated
delegated1238372delegated
deprecated1646672deprecated
desecrated1447952desecrated
detected12289732detec_ted
refected142311662refec_ted
affected1744793affec_ted
deaerate9314173deaerate_
deaerates10313643deaerates
dealated103213603de_alated
debated113916083d__ebated
debeaked1634613debe_aked
decanted122310493d__ecanted
decayed14309333d__ecayed
deceased1247713dece_ased
decimated1548953decimated
decocted1437683decoc_ted
decorated13312203decorated
dedicate12312803dedicate_
dedicatee13410343dedicatee
dedicates13311693dedicates
deducted1356243deduc_ted
deejayed2042443de_ejayed
defaced142910973def__aced
defalcate1544923defalcate_
defalcates1644543defalcates
defamed14309833def__amed
defatted1335673def_atted
defaulted1443313defaulted
defeat103817163defe_at__
defeaters13289103defe_aters
defeats113511233defe_at_s
defecating17237783defecating
defecation1679803defecation
defecators1656253defecators
defect124816173defec_t__
defector14277953defec_tor
defects134511523defec_t_s
defenced1537203defe_nced
defended1437223defe_nded
defensed1336223defe_nsed
deferred13106363defe_rred
defiladed15143473defiladed
deflate113613943def_late_
deflater123211603def_later
deflates123013943def_lates
defleaed1344953deflea_ed
defoamed15356243def_oamed
defocused16143533defocused
defoliated1545833defoliated
defrayed1635403def_rayed
defrosted1444253defrosted
delated93722873d__elated
deleaded1148333dele_aded
deleaved1346573dele_aved
delectate1248743delectate_
delectates1348193delectates
delegate10410463delegate_
delegatee1148803delegatee
delegates1139843delegates
deleted93314913dele__ted
delicate11315493delicate_
delicates12314313delicates
demarcated1645083demarcated
demeaned1237283deme_aned
demented12311273deme_nted
demerited1339073demerited
denervated1545113denervated
dentated10411703de_ntated
denudated1244933denudated
depicted1437743depic_ted
depilated1339653depilated
deprecate1477433deprecate_
deprecates1547283deprecates
depreciated1764373depreciated
depredated1544813depredated
depurated1338183depurated
derated93623503d__erated
derogated1238673derogated
descanted1336673de_scanted
desecrate1249083desecrate_
desecrater1346983desecrater
desecrates1348843desecrates
deserted101012203dese_rted
desiccated1644993desiccated
desolated1139653desolated
detecter11298733detec_ter
detested10279623dete_sted
detonated1138213detonated
detracted1357793detracted
deuterated1247533deuterated
devested13239133deve_sted
deviated13311043de_viated
directed1238233direc_ted
educated1237943_educated
effected1744993effec_ted
ejected17297653_ejec_ted
elected102812613_elec_ted
elevated12118293_elevated
erected103213993_erec_ted
execrated1938353_execrated
executed1835503_executed
federated1438423federated
generated11310203generated
hebetated1544663hebetated
infected14229403infec_ted
medicated15410073medicated
perfected1736643perfec_ted
redefeated1544883redefe_ated
redefected1743853redefec_ted
reflated123514293ref_lated
reflected1547983reflec_ted
refloated1347013refloated
refracted1557393refracted
regelated1139723regelated
reheated122415003rehe_ated
rejected182710113rejec_ted
relegated1139763relegated
relocated12710813relocated
repeated113117443repe_ated
reseated93220263rese_ated
resected112514743resec_ted
selected1159783selec_ted
telecasted1343943telecasted
undefeated1546203undefe_ated
vegetated1445083vegetated
venenated1345903venenated
venerated1339953venerated
vesicated15117653vesicated

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411427.00321225.3
3Display Results1421420.0602366.7
 (SQL Overall)1786911427.48323879.6
 
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.