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 “regelate” 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
regelate931208(None) 
regelated1139721regelated
regelates10311111regelates
regulate9313021regulate
crenelate1176512crenelate
gelate73421252__gelate
reflate103516262re_flate
reglaze1747222reg_laze
regrate82618662reg_rate
regulated11310462regulated
regulates101211722regulates
relate64033632r__elate
relegate9311242relegate
replate93420052re_plate
reslate73520592re_slate
vegetate1246672vegetate
agemate101210583_agemate
angulate9312013angulate
areolate81014453are_olate
bedplate1346223bedplate
bregmate1345533breg_mate
chelate122914893_chelate
corelate10516013corelate
crenelated1375363crenelated
crenelates1266193crenelates
crenulate1167693crenulate
deaerate9314173deaerate
dealate83617843de_alate
defecate1438793defecate
deflate113613943de_flate
deglaze1835583deg_laze
delate73827753__delate
delegate10410463delegate
depilate11311703depilate
deregulate12135193deregulate
desolate9411993desolate
egalite8311563_egalite
elate55335883___elate
elevate101110373_elevate
emulate9314123_emulate
epilate9314283_epilate
ergate7315143erg__ate
federate12310883federate
fellate10313433fe_llate
gelated93615633__gelated
gelates83219583__gelates
gelati73814533__gelati
gelato73812953__gelato
generate9312903generate
hebetate1347053hebetate
jugulate1645483jugulate
keelage1236183ke_elage
legate72917453leg__ate
legislate1084673legislate
ligulate92510253ligulate
negate72915573neg__ate
peculate122414673peculate
predebate1446163predebate
prelate9519693_prelate
racemate1239063racemate
rebate84424113r__ebate
reclame11411063re_clame
recrate92621663re_crate
recreate10313603recreate
redate74124683r__edate
reelable10311593re_elable
reelevate1245663reelevate
refelt94521423refel_t_
reflated123514293re_flated
reflates113115663re_flates
regale74821453reg__ale
regality1249313regality
regave104713383reg__ave
regear73512743rege_a_r
regeared1039433rege_ared
regears83012463rege_ars
regelating1239953regelating
regenerate1147963regenerate
regent74127673rege_nt_
regental948943regental
regents83416543rege_nts
reggae858953reg_ga_e
regilt71217493regil_t_
reginae84713453regina_e
reglazed1935743reg_lazed
reglazes1846793reg_lazes
reglet73724233reg_let_
reglets83512983reg_lets
reglue739703reg_l_ue
regmata1036193reg_mata
regolith1247543regolith
regrade92612033reg_rade
regrated102816333reg_rated
regrates92618403reg_rates
regulable1246513regulable
regular838423regula_r
regulars936253regulars
regulative1446983regulative
regulator1046973regulator
reguline939503reguline
reheat94423943rehe_at_
reheated122415003rehe_ated
reheater113413033rehe_ater
reheats104513523rehe_ats
reinflate12157403reinflate
reiterate9412933reiterate
relace83122153r__elace
related83327573r__elated
relater73723143r__elater
relates73731433r__elates
release7312763rele_ase
relegated1139763relegated
relegates10310943relegates
relocate10713533relocate
remate84428683r__emate
remediate1247543remediate
remelt85123123remel_t_
remelted11310153remel_ted
remelts93511493remel_ts
remolade1147203remolade
renegade1045123renegade
renovate1138553renovate
reoperate11410183reoperate
repeat85127213repe_at_
repeated113117443repe_ated
repeater102615443repe_ater
repeats94316053repe_ats
replace113214283re_place
replated112817523re_plated
replates102919273re_plates
replete92912993re_plete
reregulate11145953reregulate
rerelease944013rerelease
resalute857413resalute
reseat64131493rese_at_
reseated93220263rese_ated
reseats74319583rese_ats
resinate8316773resinate
reslated93517523re_slated
reslates83619503re_slates
resolute868513resolute
resonate8513513resonate
restate73824883re_state
retaliate9410643retaliate
revaluate12277103revaluate
revegetate1444053revegetate
revelator1286533revelator
reviolate1248123reviolate
revolute1176793revolute
reweave1336773rewe_ave
roseate7613453rose_ate
rosulate8310903rosulate
rugate75813813rug__ate
rugelach1442033rugelach
segregate1145073segregate
selenate81712533selenate
serenate81914883serenate
tegulated1146633tegulated
template1238433template
tesselate944183tesselate
ungulate939803ungulate
vegetated1445083vegetated
vegetates1346403vegetates
vegete1039483vege__te
velate93720143__velate
venenate1147933venenate
venerate11312903venerate

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.860207780.2
2DLD Change Limit1461621678.61016975.8
3Display Results1671670.0632650.8
 (SQL Overall)1786911679.53318744.5
 
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.