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

145 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
relocates1171293(None) 
prelocates1468351prelocates
relocate10713531relocate_
relocated12710811relocated
relocatee11810631relocatee
relocatees1275221relocatees
allocates11410472allocates
colocates13312852colocates
delicates12314312delicates
locates93218812__locates
prelocate13109522prelocate_
prelocated1597182prelocated
reallocates1354332reallocates
relates73731432rel__ates
relegates10310942relegates
reluctates1246702reluctates
renovates1248452renovates
replicates1449452replicates
resonates9412402resonates
advocates1545883advocates
allocate10411023allocate_
allocated1248093allocated
celibates1358633celibates
cellmates1347513cellmates
chlorates142512273chlorates
coelomates1497573coelomates
collocates1448123collocates
colocate12313443colocate_
colocated1439613colocated
decorates12314743decorates
dedicates13311693dedicates
defecates1538593defecates
delates83526283del__ates
delectates1348193delectates
delegates1139843delegates
delicate11315493delicate_
derogates11310973derogates
desolates10311793desolates
detonates10310433detonates
dislocates13108323dislocates
educates1139623_educates
elates65032363_el__ates
elevates111110423_elevates
elongates1045383_elongates
eluates72014683_el_uates
fellates11312753fel_lates
gelates83219583gel__ates
hellcats1346323hellcat_s
helotages1346123helotages
helpmates1645513helpmates
hemocytes1946693hemocytes
invocates1447643invocates
locales93715093__locales
locate83919843__locate_
located103114183__located
locater93113603__locater
locaters102710073__locaters
medicates14312113medicates
meliorates1288903meliorates
mislocates14107223mislocates
myelocytes2053043myelocytes
neonates8310063ne_onates
perorates11417023perorates
placates12311753_placates
predicates15410823predicates
prelates10418573prel__ates
radicates12412073radicates
reallocate1254423reallocate_
reallocated1443773reallocated
rebates95123183re__bates
recanes93222263re__canes
recites93524583re__cites
recoated113416783reco_ated
recoats92616643reco_at_s
recrates102420373re_crates
recreates11313363recreates
rectorates12410363rectorates
redates83423873re__dates
redcoats1147123redcoat_s
redictates1348233redictates
reeducates1375193reeducates
reelevates1345633reelevates
reflates113115663re_flates
refloated1347013reflo_ated
refloats1156913reflo_at_s
refocuses14135953refocuses
reformates1546263reformates
regelates10311113regelates
regrates92618403re_grates
regulates101211723regulates
reincites1148493reincites
relaces93420883rel__aces
relate64033633rel__ate_
related83327573rel__ated
relater73723143rel__ater
relaters83218153rel__aters
relaxes143215323rel__axes
releases8313343rel_eases
relegate9311243relegate_
relegated1139763relegated
relicts94414593relic_t_s
reloaded1059103relo_aded
reloader937913relo_ader
reloaders1036423relo_aders
reloads8911313relo_a_ds
reloaned939723relo_aned
reloans7313133relo_a_ns
relocating13310873relocating
relocation12312113relocation
relocations13311143relocations
relocked15217743reloc_ked
relocks134411293reloc__ks
reluctate1146923reluctate_
reluctated1345943reluctated
relucted1138653reluc_ted
relucts9369673reluc_t_s
remates93827113re__mates
remolades1246563remolades
remotes94521613remo__tes
renovate1138553renovate_
renovated1347173renovated
replates102919273re_plates
replicases1444673replicases
replicate13410043replicate_
replicated1548773replicated
reprobates1447363reprobates
reroutes8312223rero_utes
rescales103414573re_scales
resinates9314763resinates
reslates83619503re_slates
resolutes968193resolutes
resonate8513513resonate_
resonated10510613resonated
restates83423433re_states
reviolates1347533reviolates
revotes104716393revo__tes
rotates72819773r__otates
selenates91611363selenates
silicates11311523silicates
telotaxes1644643telotaxes
unlocated1238383unlocated
vellicates1545903vellicates
velocities1546473velocities
veloutes1136153velo_utes
vesicates14119033vesicates

Search took 8 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.436409841.7
2DLD Change Limit1486411457.01621186.0
3Display Results1451450.0602416.7
 (SQL Overall)1786911457.51223787.4
 
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.