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

204 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
unfished1521829(None) 
unwished15237831unwished
fished134316312__fished
outfished16116602outfished
punished1436042pun_ished
sunfishes1547032sunfishes
uncashed14299762uncashed
unfilled1298382unfilled
unfilmed1495802unfilmed
unfinished1763112unfinished
unfired112212452unfi_red
unfitted1238162unfitted
unfixed18218562unfi_xed
unfused11319512unfus_ed
unkissed1334892unkissed
unlashed12289182unlashed
unlisted9311152unlisted
unmeshed1437002unmeshed
unrushed12247572unrushed
unshed10313772un__shed
unwashed15288482unwashed
unwishes14147482unwishes
anguished1443983anguished
aniseed839403an_iseed
banished14189063banished
burnished1544923burnished
dished114318713__dished
encashed14246473encashed
englished1444273englished
enisled82510223en_isled
enlisted978193enlisted
enmeshed1444163enmeshed
enriched1435863enriched
famished1766023famished
fashed136720253__fashed
finfishes1846043finfishes
finished1536483finished
fisher124917143__fisher
fishes125221343__fishes
fisted104218703__fisted
furbished1843773furbished
furnished1644583furnished
gnashed12317523gn_ashed
incised102911583incis_ed
infested12249643infested
infirmed14205343infirmed
infixed18206563infi_xed
infused11329253infus_ed
inmeshed1444483inmeshed
insisted998673insisted
knishes1438263kn_ishes
lavished1555133lavished
lungfishes1743413lungfishes
minished1437873minished
monished1438133monished
mudfishes1844193mudfishes
neighed12135893_neighed
niched125514063_n_iched
nighed113811293_n_ighed
noised75416233_nois_ed
noshed104413503_n_oshed
outfishes15118023outfishes
outwished1655683outwished
panfishes1737593panfishes
perished14310073perished
pinfishes1746243pinfishes
pished124817063__pished
polished1468433polished
published1744343published
punisher1335773pun_isher
punishes1338113pun_ishes
pupfishes1944313pupfishes
ravished1555713ravished
relished1239433relished
snowshed1534423snowshed
squished21186393squished
sunfish1338883sunfish__
swished14418843_swished
tundishes1344543tundishes
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
unfaded123111733unf_aded
unfaked153211173unf_aked
unfasten1144843unfasten
unfazed20299053unf_azed
unfeared121511013unfeared
unfed94614223unf___ed
unfeigned1453293unfeigned
unfelted1279403unfelted
unfenced1437733unfenced
unfixes17238113unfi_xes
unflawed1536123unflawed
unflexed1935253unflexed
unfluted1237173unfluted
unfoiled12249723unfoiled
unfolded1338313unfolded
unforced14239133unforced
unforged13238623unforged
unforked16218953unforked
unformed14239573unformed
unframed1478243unframed
unfreed11510123unf_reed
unfunded1336473unfunded
unfurled1277203unfurled
unfurnished1852233unfurnished
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
unoiled82415473unoi_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
untasted92011573untasted
untested92612413untested
untidied1038903untidied
untied73720813unti__ed
untilled9710563untilled
untilted9610893untilted
untimed102713373unti_med
untinged10308943untinged
untipped1335763untipped
untired82316383unti_red
untitled978763untitled
untwisted1344863untwisted
unused72012883un_us_ed
unvested122210223unvested
unvisited1345173unvisited
unwasheds16233103unwasheds
unwasted12259783unwasted
unweighed1753663unweighed
unwilled1277823unwilled
unwise9510803unwis_e_
unwiser1037123unwis_er
unwish1239093unwish__
unwitted1237543unwitted
unzipped2233213unzipped
uprushed14234473uprushed
vanished15207743vanished
whished17428023_whished
wished134417513__wished

Search took 9 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.326548131.9
2DLD Change Limit1461622047.70618967.3
3Display Results2042040.0762684.2
 (SQL Overall)1786912048.10822038.9
 
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.