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

113 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
unlocated123838(None) 
allocated1248092allocated
colocated1439612colocated
invocated1546202invocated
located103114182__located
relocated12710812relocated
unallocated14113322unallocated
uncoated11314962unco_ated
unloaded1049532unlo_aded
unlocked15268382unloc_ked
advocated1644643advocated
allocate10411023allocate_
allocates11410473allocates
annotated1095613annotated
bilobated1444973bilobated
bloated104513433_blo_ated
collocated1546163collocated
colocate12313433colocate_
colocates13312853colocates
dislocated1497523dislocated
duplicated1655833duplicated
falcated1438473fal_cated
floated113312703_flo_ated
gloated93511533_glo_ated
globated1265753_globated
indicated13310953indicated
innovated1344573innovated
insolated1039713insolated
intonated1048303intonated
invocate1347833invocate_
invocates1447643invocates
lobated102610943__lobated
locate83919843__locate_
locater93113603__locater
locates93218813__locates
mislocated15196253mislocated
notated82713663_n_otated
onloaded1044743onlo_aded
placated1338453_placated
plicated13310643_plicated
prelocated1597183prelocated
relocate10713533relocate_
relocatee11810633relocatee
relocates11712933relocates
suffocated1942693suffocated
sulcated11310373sul_cated
tunicated12257493tun_icated
ululated947663u_lulated
unabated11310133un_abated
unacted10312733un_ac_ted
unbated103317733un__bated
unblocked1864353unbloc_ked
unbolted1179323unbo_lted
unbooted1188773unbo_oted
uncaged113314123un__caged
uncaked143514353un__caked
uncarted11312053un__carted
uncased104216953un__cased
uncloaked1635653unclo_aked
uncocked17248753uncoc_ked
uncounted1238523uncounted
uncrated11416313un_crated
uncreated12312303uncreated
undated93118463un__dated
undebated1338093undebated
undecayed1645173undecayed
undocked16277633undoc_ked
undotted1048523undo_tted
undoubted1344463undoubted
undulated11310083undulated
uneducated1444523uneducated
unelected1237823unelec_ted
unexcited1953983unexcited
unfocused1553403unfocused
ungated92717213un__gated
unheated121514553un_heated
unjointed1755583unjointed
unlaced102913733unl__aced
unladed92614373unl__aded
unleaded10411333unl_eaded
unleased9310713unl_eased
unletted9310313unl_etted
unlicked15248263unlic_ked
unlighted1455783unlighted
unlimited1245923unlimited
unlisted9311153unl_isted
unload73010803unlo_a__d
unloader936643unlo_ader
unlobed10219743unlo__bed
unlocalized2353373unlocalized
unloosed9117523unlo_osed
unloved112310533unlo__ved
unmated103317023un__mated
unmounted1245903unmounted
unnoted8311363unno__ted
unpointed1237153unpointed
unposted1159433unpo_sted
unpotted11108393unpo_tted
unrated82621553un__rated
unrelated10310433unrelated
unroasted1036613unroasted
unrooted9810513unro_oted
unsated83419933un__sated
unscaled111410113un_scaled
unscathed1535313un_scathed
unseated91317683un_seated
unsoaked1338853unso_aked
unsorted9312513unso_rted
unstated91615813un_stated
untreated10312903untreated
unwonted12248643unwo_nted
uploaded1234533uplo_aded
urticated1247693urticated

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.423422437.4
2DLD Change Limit1486411137.29620372.9
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.76523012.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.