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

202 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
educate1031021(None) 
educated1237941educated
educates1139621educates
adulate8313232adulate
aduncate1145572aduncate
dedicate12312802dedicate
ducat86225902_ducat_
ducats95011762_ducats
educable1337092educable
educative15136552educative
educator1147152educator
educe84313452educ__e
educt85017102educ_t_
educts9439892educ_ts
eluate62315432elu_ate
emulate9314122emulate
equate152012462equ_ate
eructate1047332eructate
exudate1537092exudate
medicate13513242medicate
reeducate1285492reeducate
abdicate1348903abdicate
acuate8315633acu_ate
adnate72913483ad_nate
adulated1039753adulated
adulates9311913adulates
advocate1445833advocate
aguacate1144973aguacate
arcuate9311963arcuate
aurate64426473_aurate
baccate131011263baccate
bedmate1239433bed_mate
bedplate1346223bedplate
cate66254603___cate
caudate10311353caudate
cruciate1287313cruciate
curate85226243_curate
dacite91115883_dacite
date56443323_d__ate
dealate83617843dealate
debate94419193_debate
decade104216163_decade
decane93818873_decane
decare93919153_decare
dedicated14310253dedicated
dedicatee13410343dedicatee
dedicates13311693dedicates
deduce1079253deduc__e
deduct10610793deduc_t_
deducted1356243deduc_ted
deducts1166593deduc_ts
defecate1438793defecate
deflate113613943deflate
delate73827753_delate
delicate11315493delicate
dentate8315153dentate
denudate1046163denudate
depurate1139983depurate
derate74531233_derate
deuce84517493deuc__e
deviate11312713deviate
dictate10311663_dictate
dilate73220693_dilate
donate73619503_donate
ducal84816423_duca_l
duce76933503_duc__e
duckie133511663_duckie
duct75735463_duc_t_
ductal938993_ductal
ducted104012123_duc_ted
ducts85319893_duc_ts
dunite7315013_dunite
ecarte84313503e__carte
ecaudate1145313ecaudate
edacity1336373edacity
edemata1046003edemata
edentate947703edentate
edict84722283edic_t_
edictal1046993edictal
edicts94911703edic_ts
educables1443473educables
educating1337933educating
education12310203education
educators1246993educators
educatory1545443educatory
educed10418853educ_ed
educes94011953educ_es
educible1344433educible
educing1137683educing
eductive1476863eductive
eductor1035863eductor
edulcorate1353283edulcorate
elate55335883e__late
elevate101110373elevate
eluates72014683elu_ates
elucidate1265423elucidate
elute54822573elu__te
eluviate1146953eluviate
emaciate1248753emaciate
emanate9312473emanate
emirate91015833emirate
emulated11310793emulated
emulates10312573emulates
enate54428153e__nate
encage93713503e_ncage
encase83714363e_ncase
endplate1147083endplate
enucleate1145813enucleate
enunciate1145743enunciate
epilate9314283epilate
equated171910403equ_ated
equates162012323equ_ates
eradicate1259183eradicate
ergate7315143e_rgate
eruct74022353eruc_t_
eructated1245643eructated
eructates1146953eructates
eructed10228653eruc_ted
eructs83610793eruc_ts
erudite838483erudite
escape103811663e_scape
escuage1035113escuage
estate64719763e_state
eucaine939243e_ucaine
euchre11137663e_uchre
euclase938933e_uclase
eucrite939903e_ucrite
evacuate13217303evacuate
excite15310883e_xcite
execrate1739653execrate
execute1636783execute
expiate16910593expiate
extubate1745103extubate
exudates1636623exudates
exuviate1846063exuviate
falcate12311623falcate
federate12310883federate
furcate12310453furcate
humate113214443_humate
ideate7313683id_eate
indicate11313353indicate
indurate9311873indurate
jugate14379463_jugate
leucite937753leucite
locate83919843_locate
lucite8313343_lucite
lunate6316043_lunate
luxate1338083_luxate
manducate1445773manducate
mediate103415213med_iate
medicare1347483medicare
medicated15410073medicated
medicates14312113medicates
meditate11310623meditate
medusae1044763medusa_e
miseducate1552543miseducate
modulate1138593modulate
mudcat11311203mudcat_
mudcats1236223mudcats
mutate83017483_mutate
nutate63017373_nutate
obdurate1175123obdurate
odonate848403odonate
outate62923403_outate
ovulate1039453ovulate
peculate122414673peculate
pedate93117763ped__ate
placate11312433placate
plicate11314513plicate
plumate1149803plumate
predicate14411783predicate
pupate104213123_pupate
quate144521413_qu_ate
radicate11412873radicate
redate74124683red__ate
redictate1249063redictate
reduce9713253reduc__e
reductase1244553reductase
reeducated1484823reeducated
reeducates1375193reeducates
regulate9313023regulate
relocate10713533relocate
reluctate1146923reluctate
rugate75813813_rugate
saccate111311763saccate
scutate9310323scutate
sedate73019813sed__ate
seduce9610023seduc__e
seducive1444213seducive
spicate113214193spicate
sulcate9314423sulcate
thecate123210023thecate
toccate1138773toccate
truncate1046283truncate
tubate82813173_tubate
ululate749963ululate
undulate9310403undulate
uneducated1444523uneducated
urate55432163__urate
vacate11314553_vacate
vesicate131210053vesicate
zincate1838533zincate

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.423422437.4
2DLD Change Limit1340272026.71619956.4
3Display Results2022020.0802525.0
 (SQL Overall)1786912027.21924752.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.