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

132 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
relocating1331087(None) 
prelocating1647411prelocating
allocating1347382allocating
colocating1548622colocating
locating11311502__locating
reallocating1573662reallocating
recoating121317462reco_ating
refloating14198322reflo_ating
relating92725442rel__ating
relegating1239482relegating
reloading1189882relo_ading
reloaning10710482relo_aning
relocation12312112relocation
relocations13311142relocations
relocking16137682reloc_king
reluctating1445762reluctating
relucting1239772reluc_ting
renovating1447422renovating
replicating1649092replicating
resonating11311262resonating
advocating1744483advocating
bloating113512813_blo_ating
collocating1645903collocating
decocting1538123decoc_ting
decorating14312073decorating
dedicating1539143dedicating
defecating17237783defecating
delating103119603del__ating
delectating1545993delectating
delegating1337673delegating
derogating1348633derogating
desolating1239463desolating
detonating1248823detonating
dislocating1546733dislocating
educating1337933_educating
elating83423083_el__ating
electing112113783_elec_ting
elevating1338203_elevating
eliciting1237773_eliciting
elongating1244523_elongating
fellating1339243fel_lating
floating123111883_flo_ating
gelating103015733gel__ating
gloating102611463_glo_ating
invocating1646333invocating
medicating1648953medicating
meliorating1446563meliorating
mislocating1645893mislocating
perorating13313133perorating
placating1438513_placating
predicating1749653predicating
prelecting15310163prelec_ting
preloading1446583prelo_ading
radicating1459063radicating
reacting113317893re_ac_ting
rebating112418343re__bating
rebooting12139023rebo_oting
recaning111416693re__caning
recanting122414823re__canting
recasting122414233re__casting
reciting113118073re__citing
recoaling121312453reco_aling
recocking18138373recoc_king
recounting1339193recounting
recrating121318793re_crating
recreating131214583recreating
redacting13612303redac_ting
redating102620173re__dating
redictating1546803redictating
redocking17126783redoc_king
reeducating1545163reeducating
reelecting1338783reelec_ting
reelevating1544963reelevating
reenacting1357353reenacting
refecting152413353refec_ting
reflating132514713re_flating
reflecting1638823reflec_ting
refocusing1653853refocusing
refracting1638733refracting
regelating1239953regelating
regrating111316213re_grating
regulating12310063regulating
reheating132314913re_heating
reinciting1347103reinciting
rejecting192211153rejec_ting
relacing112516043rel__acing
relaxing162612633rel__axing
relaying122515153rel__aying
releasing10411013rel_easing
relenting102716773rel_enting
reletting102713943rel_etting
relighting1545853relighting
relisting102414353rel_isting
relocate10713533relocat__e
relocated12710813relocat_ed
relocatee11810633relocat_ee
relocatees1275223relocatees
relocates11712933relocat_es
relooking14167143relo_oking
remating112322413re__mating
remounting1346673remounting
repeating122618983re_peating
replating122217403re_plating
replotting1357043replo_tting
reporting12513903repo_rting
repositing13310493repositing
repotting12511123repo_tting
reprobating1647103reprobating
rerouting10311873rero_uting
rescaling122212013re_scaling
reseating102421533re_seating
resecting122816483resec_ting
resinating11313733resinating
reslating102516993re_slating
resoaking1439373reso_aking
resorting10614613reso_rting
restating102319413re_stating
retorting10613273reto_rting
retotaling1186883retotaling
retracting13311933retracting
retreating111414773retreating
retroacting1447283retroacting
reviolating1556253reviolating
revocation15410813revocation
revocations16410313revocations
revolting1339633revo_lting
revoting12312033revo__ting
rotating92614553r__otating
selecting12310533selec_ting
telecasting1443793telecasting
vellicating1744553vellicating
vesicating1646893vesicating

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 Limit1406031326.36022107.4
3Display Results1321320.0761736.8
 (SQL Overall)1786911326.84226116.8
 
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.