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

167 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
levator1029896(None) 
elevator1146711elevator
legator83011131legator
levators11249281levators
aerator7314842aerator
delator83015032delator
deviator1248312deviator
elevators1246302elevators
lavatory1445702lavatory
lector83514992le_ctor
legato72810952legato_
legators92811032legators
legatos82711182legatos
levanter1145302levanter
levatores12225742levatores
levitator1245492levitator
locator93110422locator
negator83010672negator
relator74016372relator
senator7313072senator
abator84512723_abator
ablator939853ablator
aerators8315613aerators
aleatory1148823ale_atory
alienator946193alienator
alleviator13103303alleviator
avatar937523_avatar
aviator10229663aviator
beater84729393be_ater
belabor1136293belabor
bettor83612223be_ttor
bevatron1343883bevatron
bevor101510813bev__or
bleater94515303ble_ater
caveator1387233caveator
chelator1347923chelator
citator9310123citator
creator93714443creator
cremator1269193cremator
curator9312213curator
debater104114693debater
debtor938333de_btor
deflator12328343deflator
delators92314833delators
delegator1146243delegator
deviators1358533deviators
deviatory1666443deviatory
devisor11357043devisor
dewater112912423dewater
dilator82712793dilator
donator8310263donator
eater54639843_e_ater
editor738663_editor
elater64724203_elater
elector93313263elector
elevate101110373elevat_e
elevated12118293elevated
elevates111110423elevates
elevation1239233elevation
enactor938043_enactor
enamor838753_enamor
enervator1245523enervator
equator1637483equator
evader1036813_evader
evertor1038723_evertor
evictor12346363_evictor
evocator1346573_evocator
exactor1636633_exactor
feater95224053fe_ater
fellator1176713fellator
fetor81214533fe__tor
gator64416043__gator
gelato73812963gelato_
gelatos83111523gelatos
genitor837273genitor
gyrator1135723gyrator
heater94828303he_ater
hector113312653he_ctor
heritor10310563heritor
labor75117313l__abor
later54843923l__ater
laudator945883laudator
lavabo1135273lavabo_
lavabos1235453lavabos
lavation1139973lavation
leader74824653le_ader
leaker104620073le_aker
leaner64022193le_aner
leaper88118943le_aper
lear47045953le_a__r
leaser65322673le_aser
leather103815783le_ather
leaver94321513le_aver
leavier10319993leavier
lectors93415773le_ctors
lefter93613433le_fter
legate72917453legat_e
legated92513983legated
legatee82814633legatee
legates82917683legates
legation92412933legation
leister73212753leister
lekvar1333043lekva__r
lento57223393le_nto_
lentos65317403le_ntos
lepton82510803le_pton
lessor64010603le_ssor
letter63722583le_tter
leva77020713leva___
levant9314493leva_nt
levanted1245323levanted
levanters1254993levanters
levants1037723levants
leveler10399903leveler
lever85125163lev__er
levier94013873lev_ier
levitators1345403levitators
levity1277903levit_y
levo76820063lev__o_
liberator1147063liberator
lictor83610863l_ictor
literator948683literator
locater93113603locater
locators102910433locators
lovat8321043lovat__
lovats939073lovat_s
mediator1139043mediator
megaton10269853megaton
mentor8414363me_ntor
neater64424313ne_ater
negater83711963negater
negaton8299143negaton
negators92411173negators
nestor63713423ne_stor
obviator1344743obviator
operator10310093operator
orator6314533_orator
pleater93916333ple_ater
predator11310053predator
reactor93011663reactor
realtor73611353realtor
rebater93517913rebater
rebato83714683rebato_
rebatos92913113rebatos
rector84019753re_ctor
redactor1147033redactor
relater73723143relater
relators83316133relators
renovator1244903renovator
revelator1286533revelator
revisor10388733revisor
rotator7310833rotator
salivator12136113salivator
seater64534163se_ater
sector83415933se_ctor
sedater83713633sedater
senators8312953senators
servitor1145063servitor
stator64015483_stator
testator847373testator
tevatron1143973tevatron
tolerator956753tolerator
valor83614893__valor
vapor104013093__vapor
vavasor13143603vavasor
vector113212063ve_ctor
viator93211833_viator

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.406440125.6
2DLD Change Limit1340271677.12318816.1
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.59223536.7
 
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.