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

153 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
levators1124929(None) 
elevators1246311elevators
legators92811031legators
levator10298971levator_
levatores12225751levatores
aerators8315622aerators
delators92314832delators
deviators1358552deviators
elevator1146722elevator_
lavatory1445702lavatory
lectors93415772le_ctors
legator83011132legator_
legatos82711192legato_s
levanters1254992levanters
levitators1345412levitators
locators102910432locators
negators92411172negators
relators83316142relators
senators8312952senators
abators94413103_abators
ablators1069893ablators
aerator7314853aerator_
aleatory1148833ale_atory
alienators1045793alienators
alleviators14103203alleviators
avatars1036443_avatars
aviators11169923aviators
beaters94925043be_aters
belabors1236403belabors
bettors93312473be_ttors
bevatron1343893bevatron
bevatrons1443723bevatrons
bevors111610343bev__ors
bleaters103412323ble_aters
caveators1497263caveators
chelators1448173chelators
citators10310253citators
creators102814423creators
cremators1369833cremators
curators10311723curators
debaters113511923debaters
debtors1038533de_btors
deflators13348153deflators
delator83015033delator_
delegators1245633delegators
deviator1248333deviator_
deviatory1666463deviatory
devisors12347253devisors
dewaters122910723dewaters
dilators93213203dilators
donators9310403donators
eaters65535953_e_aters
editors839423_editors
elaters74420193_elaters
electors103013863electors
elevateds13122883elevateds
elevates111110433elevat_es
elevations1338633elevations
enactors1038463_enactors
enamors939123_enamors
enervators1345713enervators
equators1737473equators
evaders1136933_evaders
evertors1138953_evertors
evictors13276863_evictors
evocators1446713_evocators
exactors1737023_exactors
fellators1247153fellators
fetors91014473fe__tors
gators74115843__gators
gelatos83111533gelato_s
genitors937423genitors
gyrators1246003gyrators
heaters104225223he_aters
hectors123513263he_ctors
heritors11310903heritors
labors84016413l__abors
laudators1045893laudators
lavaboes1344433lavaboes
lavabos1235453lavabo_s
lavations1238973lavations
lavatories1345053lavatories
leaders83819603le_aders
leakers113415423le_akers
leaners73718173le_aners
leapers93716663le_apers
lears55938733le_a__rs
leasers74717843le_asers
leathers114215083le_athers
leavers103717783le_avers
lector83514993le_ctor_
legatees9258433legatees
legates82917683legat_es
legations102711923legations
legato72810953legato__
leisters83312823leisters
lekvars1432693lekva__rs
lentos65317403le_nto_s
leptons91910433le_ptons
lessors73610523le_ssors
letters73819853le_tters
levanter1145303levanter_
levants1037723leva_nts
levelers11259323levelers
levers94621323lev__ers
leviers103510343lev_iers
levitator1245503levitator_
levities11310713levities
liberators1247023liberators
lictors93212603l_ictors
literators1048103literators
locaters102710073locaters
locator93110423locator_
lovats939073lovat__s
mediators1248933mediators
megatons11279703megatons
mentors9314993me_ntors
negaters9349783negaters
negatons9299273negatons
negator83010673negator_
nestors73614973ne_stors
obviators1444863obviators
operators11410753operators
orators7313823_orators
pleaters103613793ple_aters
predators12310093predators
reactors103212293reactors
realtors82811683realtors
rebaters103413943rebaters
rebatos92913133rebato_s
rectors93520523re_ctors
redactors1247543redactors
relaters83218153relaters
relator74016383relator_
renovators1344843renovators
revelators13116433revelators
revisors11379073revisors
rotators8310203rotators
salivators13135753salivators
seaters74028943se_aters
sectors93116453se_ctors
senator7313073senator_
servitors1245223servitors
stators73915583_stators
testators947333testators
tevatron1143973tevatron
tevatrons1244003tevatrons
tolerators1046733tolerators
valors93413773__valors
vapors113812693__vapors
vavasors14153653vavasors
vectors123212593ve_ctors
viators102712033_viators

Search took 10 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 Limit1461621538.44017317.8
3Display Results1531530.1231243.9
 (SQL Overall)1786911538.98319892.1
 
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.