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

201 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
elatives113978(None) 
elative10312451elative_
relatives1239961relatives
ablatives1445502ablatives
datives11310072_datives
elates65032362elat__es
elations83719122elations
electives1448932electives
ergatives1346442ergatives
gelatines102910532gelatines
glaives11347832gla_ives
illatives1245522illatives
latices9313762_latices
natives10310822_natives
negatives1346582negatives
platies93722542plati_es
relative11313142relative_
sedatives1346152sedatives
statives112710792statives
abatises10311013abatises
ablative1348243ablative_
actives12311523_actives
agatizes1838863agatizes
alanines8314803alanines
alates64833963alat__es
alations82518893alations
alewives1444283alewives
amative12311733amative_
apatites10311293apatites
beladies11310423beladi_es
blasties102113633blasti_es
calmatives1744733calmatives
captives1538623captives
claries93422203clari_es
claves115020063cla__ves
creatives14279693creatives
curatives1437823curatives
dative10311813_dative_
delaines9312963dela_ines
delates83526283delat__es
delations102616593delations
dilative1239523dilative_
donatives13146903donatives
duratives1346223duratives
easies64126633e_asi_es
eatings84616443e_atings
eaves85231993e_a__ves
egalites9310503egalites
eglantines1143673eglantines
eglateres1044443eglateres
ejectives2145443ejectives
elains64919853ela_i_ns
elapids1036503elapi_ds
elapine9310673elapine_
elapses957663ela_pses
elastases946113elastases
elastics102710883elasti_cs
elastins82111743elasti_ns
elate55335883elat__e_
elated74725823elat__ed
elater64724203elat__er
elaterites1048273elaterites
elaters74420193elat_ers
elating83423083elati_ng
elation73620453elati_on
elective13311003elective_
elegies81312903elegi_es
elegises9128823elegises
elegizes18137103elegizes
elides74420693el__ides
elites66027123el__ites
elitisms1048193elitisms
elitists848543elitists
eluates72014683eluat__es
elusive1057003elusive_
elutes64020313elut__es
elutions82513053elutions
elves85118743el___ves
emetines10611053emetines
emotive1239193emotive_
empties11712243empti_es
emulative1447453emulative_
enactive1338513enactive_
enamines101112133enamines
enates64026433enat__es
enations83316903enations
endives113710693e_ndives
entices91616333e_ntices
entires71517783e_ntires
ergative1238973ergative_
erotizes17311213erotizes
eruptives1443853eruptives
etamines101611813etamines
etatisms1038293etatisms
evasive1344663evasive_
examines17128793examines
exaptive2045253exaptive_
expletives2243353expletives
fealties1139993fealti_es
fixatives2243353fixatives
flamines13311643flamines
flatlines12268433flatlines
flatuses1137173flatuses
flavines1437893flavines
gelates83219583gelat__es
gelatine93213303gelatine_
gelatins93414093gelati_ns
gelations102513093gelations
gelatis83313513gelati__s
genitives1346663genitives
glacises1138503glacises
glaires84010133gla_ires
glaive10357933gla_ive_
glaived12375973gla_ived
hematines141312203hematines
hematites141510793hematites
hepatizes2347823hepatizes
illative1147183illative_
isatines8310663isatines
klatches17157133klatches
ladies75124883_ladi_es
laities7320343_laities
lapides103012043_lapides
lapises93513463_lapises
latches123320123_latches
latexes1438313_latexes
lathes95127493_lat_hes
latigoes9306163_latigoes
latigos8277243_latigos
latinas74416463_latinas
latinos73613803_latinos
latkes104715873_lat_kes
latrines8515003_latrines
lattes65324203_lat_tes
lattices1038383_lattices
laves86039153_la__ves
lawines103313563_lawines
laxatives1943353laxatives
lazies154418783_lazi_es
lealties8310793lealti_es
leaves94222383lea__ves
lefties10312073lefti_es
lenitives1247503lenitives
lives86133193_l__ives
locatives1446563locatives
mealtimes1345243mealtimes
melamines1339763melamines
melanites11410723melanites
melanizes20410383melanizes
motives123611893_motives
naives94914223_na_ives
native9613013_native_
negative1239083negative_
negatived1444333negatived
oldwives1542463oldwives
olives94313953ol__ives
operatives15117883operatives
optatives1445203optatives
palatines11313033palatines
patines95225763_patines
plaices11411143pla_ices
platanes102711883platanes
plates85432243plat__es
platier93716293plati_er
platiest103216083plati_est
platinas103610313platinas
platings113611363platings
playtimes1644413playtimes
plosives1335893plosives
ratines75328583_ratines
ratites74920683_ratites
realties8514853realti_es
relates73731433relat__es
relations92418333relations
relatively1646803relatively
relativism1554413relativism
relativist1356233relativist
relativizes2354393relativizes
relives104619443rel__ives
salties73725773salti_es
saltines82917793saltines
saltires83112423saltires
satires72617573_satires
sedative1238853sedative_
slatches131511523slatches
slates64934063slat__es
slatier74016813slati_er
slatiest82616263slati_est
slatiness92511363slatiness
slatings94011723slatings
slaves95023023sla__ves
statices102712343statices
stative102612933stative_
teatimes1039443teatimes
tentatives1345483tentatives
velarizes2148643velarizes
vocatives1745883vocatives
volatiles1246133volatiles
votives13337953_votives
waives123714183_wa_ives
zloties1639913zloti_es

Search took 9 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.420425454.8
2DLD Change Limit1461622017.50019488.3
3Display Results2012010.0802512.5
 (SQL Overall)1786912018.00022336.4
 
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.