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

140 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
relegating123948(None) 
delegating1337671delegating
elevating1338202_elevating
legating102313112__legating
reelevating1544962reelevating
regelating1239952regelating
reheating132314912rehe_ating
relating92725442rel__ating
releasing10411012rele_asing
relegation11610022relegation
relegations1248972relegations
relenting102716772rele_nting
reletting102713942rele_tting
relighting1545852relighting
relocating13310872relocating
renegading1344592renegading
repeating122618982repe_ating
reseating102421532rese_ating
abnegating1444463abnegating
beleaping1436743bele_aping
bleating113514503_ble_ating
celebrating1646113celebrating
cleating113518133_cle_ating
crenelating1445513crenelating
deaerating12311563deaerating
defeating142311973defe_ating
defecating17237783defecating
delating103119603del__ating
deleading1237773dele_ading
deleaving1436263dele_aving
delectating1545993delectating
delegation1238883delegation
delegations1348033delegations
deleting103314423dele__ting
delighting1644993delighting
derogating1348633derogating
elating83423083_el__ating
electing112113783_ele_cting
elegising1145423_elegising
elegizing2045613_elegizing
elongating1244523_elongating
federating1548853federating
fellating1339243fel_lating
gelating103015733gel__ating
generating12310383generating
hebetating1645793hebetating
legatine91311403__legatine
levigating1545693levigating
ligating102212283__ligating
negating102012833__negating
obligating1445803obligating
pleating112916053_ple_ating
preheating16310723prehe_ating
prelecting15310163prele_cting
prelocating1647413prelocating
rebating112418343r__ebating
receipting1546753receipting
recleaning1336753recle_aning
recoating121317463re_coating
recrating121318793re_crating
recreating131214583recreating
redating102620173r__edating
redefeating1645333redefeating
reediting11310953re_editing
reelecting1338783reelecting
reenacting1357353re_enacting
reengaging1343693reengaging
reesting93118273re_e_sting
refecting152413353refe_cting
refighting1845203refighting
reflating132514713re_flating
reflecting1638823refle_cting
refloating14198323refloating
regaling10315363r__egaling
regearing112211413rege_aring
regrating111316213re_grating
regulating12310063regulating
rehearing132211763rehe_aring
reiterating12410493reiterating
rejecting192211153reje_cting
relacing112516043rel__acing
relaxing162612633rel__axing
relaying122515153rel__aying
relearning1135283relearning
relegate9311243relegat__e
relegated1139763relegat_ed
relegates10310943relegat_es
relending112412023rele_nding
relisting102414353rel_isting
reloading1189883rel_oading
reloaning10710483rel_oaning
reluctating1445763reluctating
relucting1239773rel_ucting
remating112322413r__emating
remediating1547133remediating
remeeting12311433reme_eting
remelting12311703reme_lting
remigrating1547593remigrating
reneging102111533reneg__ing
renesting102514703rene_sting
renovating1447423renovating
reoperating1449023reoperating
repealing122513543repe_aling
repegging1435593repeg_ging
repenting122316553repe_nting
replating122217403re_plating
repleading1436623reple_ading
replicating1649093replicating
rereading111212713rere_ading
reregulating1454643reregulating
rerenting102617663rere_nting
rerepeating1447183rerepeating
resealing102115673rese_aling
resecting122816483rese_cting
resenting102619293rese_nting
resetting102816293rese_tting
resighting1546073resighting
resinating11313733resinating
reslating102516993re_slating
resonating11311263resonating
restating102319413re_stating
reteaming122110443rete_aming
retearing102214253rete_aring
retesting102614603rete_sting
retreating111414773retreating
revealing132611883reve_aling
revegetating1753683revegetating
reverting132315133reve_rting
revesting132814123reve_sting
revetting132912633reve_tting
rewearing132310703rewe_aring
reweaving16227073rewe_aving
rewetting132710443rewe_tting
segregating1445453segregating
selecting12310533sele_cting
telecasting1443793telecasting
tolerating1148593tolerating
vegetating1545703vegetating
venenating1446013venenating
venerating14410053venerating

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 Filter1786911406030.406440125.6
2DLD Change Limit1406031405.65624859.1
3Display Results1401400.0632222.2
 (SQL Overall)1786911406.12529174.0
 
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.