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

158 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
relegates1031094(None) 
delegates1139841delegates
relegate9311241relegate_
relegated1139761relegated
ablegates1246792ablegates
delegate10410462delegate_
delegated1238372delegated
delegatee1148802delegatee
delegatees1244272delegatees
elevates111110422_elevates
legates82917682__legates
reelevates1345632reelevates
regelates10311112regelates
relates73731432rel__ates
releases8313342rele_ases
relocates11712932relocates
renegades1145122renegades
selenates91611362selenates
ablegate1147253ablegate_
abnegates1244943abnegates
celebrates1447673celebrates
celestes10310013cele_stes
celibates1358633celibates
cellmates1347513cellmates
crenelates1266193crenelates
deaerates10313643deaerates
defecates1538593defecates
delates83526283del__ates
deleaves1248063dele_aves
delectates1348193delectates
delegacies1444033delegacies
delegator1146243delegator
delegators1245633delegators
deletes83117933dele__tes
delicates12314313delicates
derogates11310973derogates
elates65032363_el__ates
elegances1246183_elegances
elegies81312903_eleg_ies
elegises9128823_elegises
elegits8149343_elegit_s
elegizes18137103_elegizes
elevate101110373_elevate_
elevated12118293_elevated
elevateds13122883_elevateds
elongates1045383_elongates
eluates72014683_el_uates
ergates8314493_e_rgates
exegetes1655313_exegetes
federates13310153federates
fellates11312753fel_lates
gelates83219593gel__ates
generates10312713generates
headgates1446383headgates
hebetates1446433hebetates
helpmates1645513helpmates
legate72917453__legate_
legated92513983__legated
legatee82814633__legatee
legatees9258433__legatees
legatos82711183__legatos
levigates1346493levigates
ligates82318383__ligates
maleates103316343male_ates
negates83215843__negates
obligates12207853obligates
oleates7417833_ole_ates
prelates10418573prel__ates
prelocates1468353prelocates
racemates1348853racemates
rebates95123183r__ebates
recrates102420373re_crates
recreates11313363recreates
redates83423873r__edates
reelevate1245663reelevate_
reelevated1445153reelevated
reengages1145343reengages
reflates113115663re_flates
regales83520793r__egales
regelate9312083regelate_
regelated1139723regelated
reggaes948883re_gga_es
regrates92618403re_grates
regulates101211723regulates
reheated122415003rehe_ated
reheater113413033rehe_ater
reheaters122010273rehe_aters
reheats104513523rehe_at_s
reiterates10412003reiterates
relaces93420883rel__aces
relate64033633rel__ate_
related83327573rel__ated
relater73723143rel__ater
relaters83218153rel__aters
relaxes143215323rel__axes
relearns836303rele_arns
release7312763rele_ase_
released9310243rele_ased
releaser839503rele_aser
releasers937323rele_asers
relegable1258103relegable
relegating1239483relegating
relegation11610023relegation
relegations1248973relegations
relented92614943rele_nted
relents74018503rele_nt_s
relets64025673rele__t_s
reletter81311023rele_tter
reletters9138783rele_tters
relevances1596113relevances
releves103914973rele__ves
relighted1436863relighted
relights1248053relight_s
relocate10713533relocate_
relocated12710813relocated
relocatee11810633relocatee
relocatees1275223relocatees
reluctates1246703reluctates
remates93827113r__emates
remediates1346933remediates
remigrates1348583remigrates
renegade1045123renegade_
renegaded1244603renegaded
renegadoes1252263renegadoes
renegados1142543renegados
reneges82513593reneg__es
renovates1248453renovates
reoperates1249663reoperates
repeated113117443repe_ated
repeater102615443repe_ater
repeaters112811993repe_aters
repeats94316053repe_at_s
replates102919273re_plates
repletes102812473reple__tes
replicates1449453replicates
reregulates12135803reregulates
reseated93220263rese_ated
reseats74319583rese_at_s
resinates9314763resinates
reslates83619503re_slates
resonates9412403resonates
restates83423433re_states
revegetates1553933revegetates
reweaves1436603rewe_aves
runagates1044333runagates
segregates1245333segregates
selenate81712533selenate_
selenites91312093selenites
telefaxes1943813telefaxes
telegas837443telega__s
telepaths1444413telepaths
tolerates9312123tolerates
tollgates1046053tollgates
valerates12310543valerates
vegetates1346403vegetates
venenates1247583venenates
venerates12312263venerates
vulgates12237233vul_gates

Search took 9 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411587.62319499.0
3Display Results1581580.0632507.9
 (SQL Overall)1786911588.10922036.1
 
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.