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

117 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
relocation1231211(None) 
relocations13311141relocations
revocation15410811revocation
allocation1248572allocation
bilocation1446122bilocation
elocution1145672_elocution
evocation142010292_evocation
location102113912__location
reallocation1454492reallocation
relation82619772rel__ation
relaxation1746452relaxation
relegation11610022relegation
reliction11310692relic_tion
relocating13310872relocating
reluctation1347962reluctation
renovation1358782renovation
replication15712012replication
revocations16410312revocations
advocation1645743advocation
allocations1347773allocations
allocution1244083allocution
avocation14168993_avocation
bilocations1545293bilocations
collocation1547173collocation
coloration12913183coloration
decoction1447523decoc_tion
decoration13314423decoration
dedication14311963dedication
defecation1679803defecation
defloration1547263defloration
delation92318083del__ation
delectation1448553delectation
delegation1238883delegation
denotation11311083denotation
derogation12410393derogation
desolation11311403desolation
detonation11310943detonation
dislocation14147503dislocation
education12310203_education
elation73620453_el__ation
election102015353_elec_tion
elevation1239233_elevation
elocutions1245963_elocutions
elongation1145353_elongation
evocations15259873_evocations
fellation1238843fel_lation
flotation1267813_flotation
gelation93014433gel__ation
invocation1547543invocation
lobation102110553__lobation
locations112512743__locations
locution10227663__locution
medication15411173medication
melioration1368183melioration
mislocation15126413mislocation
peltation11312963pel_tation
peroration12316003peroration
placation1339773_placation
plication13311683_plication
predication16412433predication
prelection141511293prelec_tion
prelibation15128663prelibation
prelocating1647413prelocating
provocation1847353provocation
reaction10612603re_ac_tion
realization20417223realization
reallocations1553803reallocations
recaution1148093re__caution
recitation12315943recitation
reclamation1546353reclamation
recordation1449263recordation
recreation12413613recreation
redaction1259663redac_tion
reduction1259903reduc_tion
reeducation1445933reeducation
reelection12198633reelec_tion
refection141512283refec_tion
reflation12412333re_flation
reflection15168993reflec_tion
reformation1648413reformation
refraction15137903refraction
refutation1349913refutation
regulation11312053regulation
reification16412903reification
rejection181710253rejec_tion
relations92418333rel__ations
relaxations1845643relaxations
relegations1248973relegations
relictions12310023relic_tions
relocate10713533relocat__e
relocated12710813relocat_ed
relocatee11810633relocat_ee
relocatees1275223relocatees
relocates11712933relocat_es
reluctations1446753reluctations
remotion10410233remo__tion
renovations1448423renovations
reparation12612723reparation
replications16811053replications
reposition121010143reposition
reprobation1548503reprobation
reputation12411883reputation
resection111613273resec_tion
resolution1097733resolution
resorption1247253resorption
restation9316913re_station
restoration11412093restoration
retortion949673reto_rtion
retraction121310533retraction
retroaction1347363retroaction
revelation13410923revelation
revolution13117563revolution
rogation91612053r__ogation
rotation81615453r__otation
selection11311273selec_tion
sulcation11710733sul_cation
vocation132311983__vocation

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.423422437.4
2DLD Change Limit1406031176.12322963.1
3Display Results1171170.0462543.5
 (SQL Overall)1786911176.59227107.3
 
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.