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

210 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
unwished1523783(None) 
unfished15218291unfished
unwashed15288481unwashed
unwishes14147481unwishes
outwished1655682outwished
punished1436042pun_ished
swished14418842_swished
uncashed14299762uncashed
unkissed1334892unkissed
unlashed12289182unlashed
unlisted9311152unlisted
unmeshed1437002unmeshed
unrushed12247572unrushed
unshed10313772un__shed
untwisted1344862untwisted
unwasheds16233102unwasheds
unwasted12259782unwasted
unweighed1753662unweighed
unwilled1277822unwilled
unwise9510802unwis_e_
unwiser1037122unwis_er
unwish1239092unwish__
unwitted1237542unwitted
wished134417512__wished
anguished1443983anguished
aniseed839403an_iseed
banished14189063banished
burnished1544923burnished
cowshed1637773cow_shed
dished114318713__dished
encashed14246473encashed
englished1444273englished
enisled82510223en_isled
enlisted978193enlisted
enmeshed1444163enmeshed
enriched1435863enriched
entwisted1343803entwisted
famished1766023famished
finished1536483finished
fished134316313__fished
furbished1843773furbished
furnished1644583furnished
gnashed12317523gn_ashed
incised102911583incis_ed
inmeshed1444483inmeshed
insisted998673insisted
intwisted1344333intwisted
knishes1438263kn_ishes
lavished1555133lavished
minished1437873minished
monished1438133monished
neighed12135893_neighed
niched125514063_n_iched
nighed113811293_n_ighed
noised75416233_nois_ed
noshed104413503_n_oshed
outfished16116603outfished
outwishes15126563outwishes
perished14310083perished
pished124817063__pished
polished1468433polished
published1744343published
punisher1335773pun_isher
punishes1338113pun_ishes
ravished1555713ravished
relished1239433relished
rewashed1546243rewashed
snowshed1534423snowshed
squished21186393squished
sunfishes1547033sunfishes
sunwise1036433sunwis_e_
swashed144311363_swashed
swisher13369523_swisher
swishes133411373_swishes
tundishes1344543tundishes
twisted11277433_twisted
unabashed1544103unabashed
unaided92414603unai_ded
unaimed102812493unai_med
unaired82916013unai_red
unarched14128553unarched
unasked122010023un_asked
unbased103513483unbas_ed
unbasted112510073unbasted
unbathed1437223unbathed
unbiased1147153unbiased
unbiassed1243553unbiassed
unbilled1188693unbilled
unbitted1138213unbitted
unbrushed1544433unbrushed
unbusted11258773unbusted
uncased104216953uncas_ed
uncasked15278453uncasked
uncliched1744623uncliched
uncrushed1545023uncrushed
undimmed1434113undimmed
unfilled1298383unfilled
unfilmed1495803unfilmed
unfinished1763113unfinished
unfired112212453unfi_red
unfitted1238163unfitted
unfixed18218563unfi_xed
unfused11319513unfus_ed
ungifted13116833ungifted
ungirded1136083ungirded
unhinged13257473unhinged
unhired112512153unhi_red
unhitched1843093unhitched
unhusked1634603unhusked
unified112413573un_ified
unisex1358353un_is_ex
unissued934683unissued
united74421543un_i_ted
unkinked12215903unkinked
unkosher1573763unkosher
unlashes11238043unlashes
unleashed1345403unleashed
unlicked15248263unlicked
unlighted1455783unlighted
unliked122411283unli_ked
unlined82515803unli_ned
unlinked13237793unlinked
unlived112511373unli_ved
unmasked15267143unmasked
unmeshes1346153unmeshes
unmilled1197853unmilled
unmined102612953unmi_ned
unmitred1136843unmitred
unmixed17228213unmi_xed
unoiled82415483unoi_led
unpicked17237213unpicked
unpiled102312743unpi_led
unpinned1136383unpinned
unpitied1138793unpitied
unpitted1148623unpitted
unpoised1139183unpois_ed
unpolished1643433unpolished
unposed10711903unpos_ed
unposted1159433unposted
unpunished1642523unpunished
unraised91811883unrais_ed
unravished1742773unravished
unrested91914513unrested
unribbed1334173unribbed
unrifled1237423unrifled
unrigged1165643unrigged
unrimed102211633unri_med
unrinsed938383unrinsed
unripped1335763unripped
unrisen7229283unris_en
unrusted92310353unrusted
unshod1067603un__shod
unsifted12128773unsifted
unsighted1455433unsighted
unsigned1037563unsigned
unsized172510543unsi_zed
unswathed1634543unswathed
untasted92011573untasted
untested92612413untested
untidied1038903untidied
untied73720813unti__ed
untilled9710563untilled
untilted9610893untilted
untimed102713373unti_med
untinged10308943untinged
untipped1335763untipped
untired82316383unti_red
untitled978763untitled
untwilled1343873untwilled
untwined1237063untwi_ned
unused72012883un_us_ed
unvested122210223unvested
unvisited1345173unvisited
unwalled1288653unwalled
unwanted12249603unwanted
unwarmed1437303unwarmed
unwarned1238453unwarned
unwarped1436873unwarped
unwatched1844083unwatched
unwaxed18308393unw_axed
unweaned1238593unweaned
unwed94114873unw___ed
unwedded1435403unwedded
unweeded1336573unweeded
unweighted1843153unweighted
unwelded1337143unwelded
unwetted1238123unwetted
unwhipped2042363unwhipped
unwind102610543unwi__nd
unwinder1235613unwinder
unwisdom1441813unwisdom
unwisely1444463unwisely
unwisest1165123unwisest
unwishing1635593unwishing
unwonted12248643unwonted
unwooded13207443unwooded
unwooed11229773unw_ooed
unworked16238503unworked
unzipped2233213unzipped
uprushed14234473uprushed
vanished15207743vanished
washed135521503__washed
whished17428023_whished
wised95123343__wis_ed
wisher123617063__wisher
wishes124920953__wishes
wisped123411893__wisped
wissed104114643__wissed
wisted104120273__wisted
withed134416233__withed

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622106.97020970.2
3Display Results2102100.0762763.2
 (SQL Overall)1786912107.46923924.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.