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

179 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
legator8301113(None) 
legato72810951legato_
legators92811031legators
legatos82711181legatos
levator10298961levator
negator83010671negator
aerator7314842aerator
delator83015022delator
delegator1146242delegator
elevator1146712elevator
gator64416032__gator
lector83514982le_ctor
legate72917452legat_e
legated92513982legated
legatee82814632legatee
legates82917682legates
legation92412932legation
levators11249282levators
locator93110422locator
megaton10269852megaton
negater83711962negater
negaton8299142negaton
negators92411172negators
relator74016362relator
senator7313072senator
abator84512713_abator
ablator939843ablator
abnegator1243593abnegator
aerators8315613aerators
aleatory1148813ale_atory
alegar739283alega__r
alienator946193alienator
alligator1046113alligator
aviator10229663aviator
avigator12236773avigator
beater84729393be_ater
begat86629723begat__
beglamor1383193beglamor
belabor1136293belabor
bettor83612223be_ttor
bleater94515303ble_ater
chelator1347913chelator
citator9310123citator
creator93714443creator
cremator1269183cremator
curator9312213curator
debater104114693debater
debtor938333de_btor
deflator12328343deflator
delators92314823delators
delegators1245633delegators
deviator1248313deviator
dewater112912423dewater
dilator82712783dilator
donator8310263donator
eater54639843_e_ater
editor738663_editor
elater64724203_elater
elector93313253elector
elevators1246303elevators
enactor938033_enactor
enamor838753_enamor
equator1637483equator
exactor1636623_exactor
feater95224053fe_ater
fellator1176713fellator
fetor81214533fe__tor
fugato1036223fugato_
fugatos1135483fugatos
gater64533653__gater
gators74115833__gators
gelato73812953gelato_
gelatos83111513gelatos
genitor837273genitor
gigaton946343gigaton
gyrator1135713gyrator
heater94828303he_ater
hector113312653he_ctor
heritor10310563heritor
labor75117313l__abor
later54843923l__ater
laudator945883laudator
lavatory1445693lavatory
leader74824653le_ader
leaguer835793leaguer
leaker104620073le_aker
leaner64022193le_aner
leaper88118943le_aper
lear47045953le_a__r
leaser65322673le_aser
leather103815783le_ather
leaver94321513le_aver
lectors93415763le_ctors
lefter93613433le_fter
legacy1256653lega_cy
legal65715943lega__l
legally1138133legally
legals73412733lega_ls
legatees9258433legatees
legatine91311403legatine
legating102313113legating
legations102711923legations
leger65721513leg__er
leggier9368233leggier
leghorn1146223leg_horn
legion75712983leg_ion
legislator1162853legislator
legit61323503legit__
legits71313003legit_s
legroom1076093legroom
legwork1545663leg_work
leister73212753leister
lento57223393le_nto_
lentos65317403le_ntos
lepton82510803le_pton
lessor64010603le_ssor
letter63722583le_tter
levanter1145303levanter
levatores12225733levatores
levitator1245493levitator
liberator1147063liberator
lictor83610853l_ictor
ligate72519253ligat_e
ligated92414143ligated
ligates82318383ligates
ligation92313093ligation
ligature945133ligature
lighter113113443lighter
literator948683literator
litigator1045503litigator
locater93113603locater
locators102910433locators
mediator1139043mediator
megabar1244503megabar
megapod1344893megapod
megaron10248303megaron
megastar1143533megastar
megatons11279703megatons
mentor8414363me_ntor
migrator1147873migrator
neater64424313ne_ater
negate72915573negat_e
negated93413233negated
negaters9349783negaters
negates83215843negates
negation92913023negation
negatons9299273negatons
negatron9335993negatron
nestor63713423ne_stor
nugatory1245273nugatory
obligator12195693obligator
operator10310093operator
orator6314533_orator
pleater93916333ple_ater
predator11310053predator
reactor93011653reactor
realtor73611353realtor
rebater93517913rebater
rebato83714683rebato_
rebatos92913113rebatos
rector84019753re_ctor
redactor1147023redactor
regaler83814623regaler
regather1236733regather
regatta835963regatta
regulator1046973regulator
relater73723143relater
relators83316123relators
rogatory1246153rogatory
rotator7310833rotator
seater64534163se_ater
sector83415933se_ctor
sedater83713633sedater
senators8312953senators
stator64015483_stator
testator847373testator
tolerator956753tolerator
vector113212063ve_ctor
viator93211833_viator

Search took 7 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.403443402.0
2DLD Change Limit1340271795.87622809.2
3Display Results1791790.0632841.3
 (SQL Overall)1786911796.34228175.8
 
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.