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

126 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
nickeled1511551(None) 
nickelled1653791nickelled
nickered15117021nickered
nickled144010441nick_led
bickered17108002bickered
dickered16117532dickered
nicked135019682nick__ed
nickel123811342nickel__
nickelic1643272nickelic
nickels13338652nickel_s
nickle123814482nick_le_
nickles133713822nick_les
picketed17167382picketed
pickled164011882pick_led
sickened1546782sickened
sickled144713432sick_led
snickered16115342snickered
ticketed15146642ticketed
tickled144313132tick_led
bickerer16106773bickerer
bicycled1843133bicycled
bucketed1736763bucketed
buckled164411883buck_led
cackled164613303cack_led
chickened2144623chickened
cockered17710213cockered
cockeyed2096123cockeyed
cockled163710823cock_led
cricketed1854683cricketed
dackered16116893dackered
dicked144920863dick__ed
dieseled1035523dieseled
docketed16156583docketed
fickle153912973fick_le_
fickler16348423fick_ler
flickered1943753flickered
hackled173312493hack_led
heckled17318463heck_led
hirseled12106253hirseled
icicled1234293_icicled
jacketed22146533jacketed
jockeyed2563413jockeyed
keckled13376503keck_led
kicked124415943kick__ed
knackered1543683knackered
knuckled1463563knuck_led
lackered15108673lackered
lackeyed18104513lackeyed
libeled10249413li_beled
lichened1435753lichened
licked134621563lick__ed
likened12267353li_kened
mackled164111923mack_led
mickle143715133mick_le_
mickler153310233mick_ler
mickles153415003mick_les
necked134715063neck__ed
nibbled12389073ni_bbled
nicely1139493nic_el_y
niched125514063nic__hed
nickeling1645393nickeling
nickelous1553413nickelous
nicker123818703nick__er
nickers134415093nicke_rs
nicknamed1842153nicknamed
nictated1137793nictated
niffered1544143niffered
niggled10319203ni_ggled
nilled73919453ni__lled
nippled12307643ni_ppled
nocked134617383nock__ed
packeted17148283packeted
pickaxed2443513pickaxed
picked154421313pick__ed
pickeer153710113picke_er
pickeered1843463pickeered
pickerel1645273pickerel
picketer16187433picketer
pickle144215653pick_le_
pickles153215443pick_les
pinkened1535753pinkened
pocketed17147143pocketed
prickled17358073prick_led
puckered1736103puckered
quickened2543163quickened
racketed15169123racketed
richened1435953richened
ricked136523623rick__ed
rocketed15157793rocketed
ruckled144111033ruck_led
shickered19115723shickered
sickbed16396823sick_bed
sicked134524403sick__ed
sickee124622223sicke_e_
sickees134514213sicke_es
sickener1436603sickener
sickle124418323sick_le_
sickles133417543sick_les
sicklied1546583sicklied
slickened1644293slickened
snicked143811633snick__ed
snickerer15134563snickerer
sniveled1255463sni_veled
snorkeled1442883snorkeled
socketed15177343socketed
stickled15298973stick_led
suckered1537833suckered
suckled144212513suck_led
tackled143913193tack_led
thickened1944303thickened
thicketed1943613thicketed
ticked134720523tick__ed
tickle124616743tick_le_
tickler133612653tick_ler
tickles133416853tick_les
tickseed1584513tickseed
tinkered1387683tinkered
tinkled123910473tink_led
tinseled935763tinseled
trickled152610433trick_led
tuckered1535963tuckered
unicycled17143503unicycled
whickered22114033whickered
wicked164317413wick__ed
wickeder1843983wickeder
winkled15299593wink_led

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621266.37622923.8
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.84526105.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.