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

173 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
erudite83848(None) 
cerusite1047762cerusite
crudites1137762crudites
crudity1336042crudity
endite73817592e_ndite
eradiate91911752eradiate
eremite9312832eremite
eruditely1342702eruditely
exudate1537092exudate
reunite7312712reunite
aerolite8315053aerolite
alunite7311633alunite
arenite71017713arenite
aridity11510113aridity
audile73315303_audile
audit62527883_audit_
audited939033_audited
auditee8311573_auditee
audits72814113_audits
augite7312613_augite
azurite1638003azurite
bauxite1635573bauxite
braunite1047253braunite
brucine1138273brucine
bruise83412873bru_ise
bruit76126723bru_it_
bruited104110353bru_ited
bruiter93710633bru_iter
bruits85714453bru_its
brute75321783bru__te
burdie93615023burdi_e
burkite1337003burkite
caudate10311353caudate
cerite84724873cer__ite
cerusites1146523cerusites
cerussite1144013cerussite
chedite1338863chedite
cordite10315263cordite
credit9315193credit_
credited1238253credited
credits1039973credits
crinite9513633crinite
cruciate1287313cruciate
crude86018573crud__e
crudities1247743crudities
cruise84314043cru_ise
curite85222943_curite
denudate1046163denudate
dite55547553___dite
drudge9317903drud_ge
dunite7315013_dunite
ebonite9310293ebonite
ecaudate1145313ecaudate
edile64819493e__dile
edit54934863e__dit_
edited83913673e__dited
edits65819033e__dits
educate10310213educate
egalite8311563egalite
elite56230183e__lite
eluate62315433elu_ate
elude64517623elud__e
eluding93412113eluding
elusive1057003elusive
elute54822573elu__te
eluviate1146953eluviate
emulate9314123emulate
endited93512913e_ndited
endites83717063e_ndites
endive103310473e_ndive
epidote1037393epidote
equate152012463equ_ate
equine151711573equ_ine
equites162212493equ_ites
equity1838103equ_ity
eradiated11178813eradiated
eradiates102010783eradiates
eradicate1259183eradicate
eremites10312603eremites
ergate7315143er_gate
ermine8416923er_mine
erode64520993erod__e
erodible1145493erodible
eroding9314273eroding
erosive1039193erosive
erotize16311663erotize
errhine1036593errhine
eruct74022353eru_ct_
eructate1047333eructate
eructed10228653eru_cted
eructs83610793eru_cts
erudition1046173erudition
erupt74220063eru_pt_
erupted10207163eru_pted
eruptive1345793eruptive
erupts8348903eru_pts
etude63612303etud__e
eucrite939903eucrite
evite85317683e__vite
excite15310883e_xcite
expedite1847263expedite
extradite1746433extradite
exudates1636623exudates
exude134010293exud__e
exuding16347443exuding
exuviae1744343exuviae
exuviate1846063exuviate
ferrite103312753fer_rite
fruit85122223fru_it_
fruited11389093fru_ited
fruiter10309683fru_iter
fruits94512493fru_its
fruity12429693fru_ity
gerundive1442073gerundive
gradate9511233gradate
gradine93317033gradine
granite82017083granite
grudge9388583grud_ge
gunite7414403_gunite
heredity1546493heredity
indite73520323_indite
kernite1159473ker_nite
leucite937753leucite
lucite8313343_lucite
lyddite1243333lyddite
nudie65118673_nudi_e
nudity1037993_nudity
perdie94718513per_di_e
perlite9317323per_lite
podite93315353_podite
predate10616893predate
predive13511083predive
preunite1039573preunite
prude84615973prud__e
prudish1376563prudish
quite144621463_qu_ite
radiate83416313_radiate
ratite65022423_ratite
recite83625113_recite
redate74124683_redate
rediae74221993_rediae
reedit7617223reedit_
reedited10310083reedited
reedits8511743reedits
repudiate1246183repudiate
requite162012483requite
reradiate10179033reradiate
resite64128453_resite
respite9513033respite
reunited939713reunited
reuniter838323reuniter
reunites8312473reunites
rewrite10311143rewrite
rite45849453_r__ite
ruddle83414203_ruddle
rude55632783_rud__e
rugate75813813_rugate
rusine63916593_rusine
rutile65217683_rutile
suite54829563_su_ite
tergite8311003ter_gite
termite9313893ter_mite
trite54730033tr__ite
trudge8318733trud_ge
turdine8310283turdine
turgite837973turgite
unite54828383__unite
uralite71714103uralite
uranite72515693uranite
uridine81311213uridine
verditer1236223ver_diter
verite94323443ver__ite
write85522833wr__ite

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271737.03019065.0
3Display Results1731730.0802162.5
 (SQL Overall)1786911737.53023730.5
 
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.