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

165 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
legators9281103(None) 
legator83011131legator_
legatos82711181legato_s
levators11249281levators
negators92411171negators
aerators8315612aerators
delators92314822delators
delegators1245632delegators
elevators1246302elevators
gators74115832__gators
lectors93415762le_ctors
legatees9258432legatees
legates82917682legat_es
legations102711922legations
legato72810952legato__
levator10298962levator_
levatores12225732levatores
locators102910432locators
megatons11279702megatons
negaters9349782negaters
negatons9299272negatons
negator83010672negator_
relators83316122relators
senators8312952senators
abators94413083_abators
ablators1069873ablators
abnegators1343673abnegators
aerator7314843aerator_
aleatory1148813ale_atory
alegars838933alega__rs
alienators1045783alienators
alligators1145773alligators
aviators11169903aviators
avigators13177093avigators
beaters94925043be_aters
beglamors1473373beglamors
belabors1236403belabors
bettors93312473be_ttors
bleaters103412323ble_aters
chelators1448163chelators
citators10310253citators
creators102814413creators
cremators1369813cremators
curators10311723curators
debaters113511923debaters
debtors1038533de_btors
deflators13348153deflators
delator83015023delator_
delegator1146243delegator_
deviators1358533deviators
dewaters122910723dewaters
dilators93213193dilators
donators9310403donators
eaters65535953_e_aters
editors839423_editors
elaters74420193_elaters
electors103013843electors
elevator1146713elevator_
enactors1038453_enactors
enamors939123_enamors
equators1737473equators
exactors1737013_exactors
fellators1247143fellators
fetors91014473fe__tors
fugatos1135483fugato_s
gaters74728643__gaters
gator64416033__gator_
gelatos83111513gelato_s
genitors937423genitors
gigatons1046053gigatons
gyrators1245993gyrators
heaters104225223he_aters
hectors123513263he_ctors
heritors11310903heritors
labors84016413l__abors
laudators1045893laudators
lavatory1445693lavatory
leaders83819603le_aders
leaguers935063leaguers
leakers113415423le_akers
leaners73718173le_aners
leapers93716663le_apers
lears55938733le_a__rs
leasers74717843le_asers
leathers114215083le_athers
leavers103717783le_avers
lector83514983le_ctor_
legacies1139043legacies
legals73412733lega__ls
legate72917453legat__e
legated92513983legat_ed
legatee82814633legat_ee
legatine91311403legatine
legating102313113legating
legation92412933legation
legers74518313leg__ers
leghorn1146223leg_horn
leghorns1244903leg_horns
legions84611783leg_ions
legislators1273053legislators
legits71313003legit__s
legrooms1185413legrooms
legwork1545663leg_work
legworks1645373leg_works
leisters83312823leisters
lentos65317403le_nto_s
leptons91910433le_ptons
lessors73610523le_ssors
letters73819853le_tters
levanters1254993levanters
levitators1345403levitators
liberators1247013liberators
lictors93212593l_ictors
ligates82318383ligat_es
ligations102111993ligations
ligature945133ligature
ligatures1044933ligatures
lighters123111393lighters
literators1048103literators
litigators1145383litigators
locaters102710073locaters
locator93110423locator_
mediators1248923mediators
megabars1344403megabars
megalops1356123megalops
megapods1444903megapods
megastars1243653megastars
megaton10269853megato_n
mentors9314993me_ntors
migrators1247543migrators
negater83711963negater_
negates83215843negat_es
negations102811963negations
negaton8299143negato_n
negatron9335993negatron
negatrons10275843negatrons
nestors73614973ne_stors
nugatory1245273nugatory
obligators13195443obligators
operators11410753operators
orators7313823_orators
pleaters103613793ple_aters
predators12310083predators
reactors103212283reactors
realtors82811683realtors
rebaters103413943rebaters
rebatos92913113rebato_s
rectors93520523re_ctors
redactors1247533redactors
regalers94311133regalers
regathers1336353regathers
regattas944473regattas
regulators1146503regulators
relaters83218153relaters
relator74016363relator_
rogatory1246153rogatory
rotators8310203rotators
seaters74028943se_aters
sectors93116453se_ctors
senator7313073senator_
stators73915583_stators
testators947333testators
tolerators1046733tolerators
vectors123212593ve_ctors
viators102712023_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.453394461.4
2DLD Change Limit1461621658.97016294.5
3Display Results1651650.0802062.5
 (SQL Overall)1786911659.50318803.6
 
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.