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

63 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
aduncate114557(None) 
adnate72913482ad_n_ate
adulate8313232adu_late
advocate1445832advocate
aguacate1144972aguacate
educate10310212edu_cate
truncate1046282truncate
abdicate1348903abdicate
acuate8315633acu__ate
aculeate1039923aculeate
adequate1844303adequate
adjudicate2152263adjudicate
adjunct1753583adjunc_t_
adjuncts1842463adjunc_ts
adulated1039753adu_lated
adulates9311913adu_lates
adumbrate1453363adumbrate
adunc837433adunc___
aduncous1143163aduncous
advocated1644643advocated
advocates1545883advocates
agnate73314883a_gn_ate
aguacates1244583aguacates
allocate10411023allocate
alunite7311633alun_ite
annulate8310923annulate
annunciate12113013annunciate
ansate64517863a__nsate
aquacade2043343aquacade
aurate64426473a_u_rate
aureate72515283a_ureate
coadunate1245643coadun_ate
cuneate9311723_cuneate
dentate8315153_dentate
donate73619503_don_ate
ducat86225903_du_cat_
ducats95011763_du_cats
dunce86319263_dunc__e
dunite7315013_dun_ite
dunnage9175213_dunnage
dunnite857333_dunnite
edentate947703edentate
educated1237943edu_cated
educates1139623edu_cates
enunciate1145743enunciate
furcate12310453_furcate
inundate946043inundate
lacunate10128963lacun_ate
lunate6316043_lun_ate
manducate1445773mandu_cate
odonate848403odon_ate
punctate1246473_punctate
radicate11412873rad_icate
sulcate9314423_sulcate
truncated1244583truncated
truncates1145843truncates
tunicate103310043_tunicate
uncage93014873__uncage
uncake122813523__uncake
uncase83817433__uncase
uncrate9415953__uncrate
uncute82912133__uncute
zincate1838533_zincate

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 Filter1786911461620.440406115.9
2DLD Change Limit146162636.82621412.5
3Display Results63630.0331909.1
 (SQL Overall)178691637.29924481.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.