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

125 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
famished176602(None) 
famishes1658281famishes
banished14189062banished
faithed1437162fa_ithed
famish14311842famish__
fashed136720252fa__shed
finished1536482finished
fished134316312f__ished
flemished1853632flemished
lavished1555132lavished
ravished1555712ravished
vanished15207742vanished
wampished2042802wampished
abashed1357663_abashed
agisted938203_agisted
airshed11258533_airshed
aisled74516183_a_isled
amassed10388633_amassed
ambushed1644463_ambushed
amused94412513_amus_ed
aniseed839403_aniseed
ashed97829773_a__shed
axised14438963_axis_ed
banisher13169183banisher
banishes131812463banishes
bashed126225703ba__shed
bemisted1368383bemisted
blemished1763783blemished
caboshed1634393caboshed
camisade1374823camisade
camise103319633camis_e_
camises114218463camis_es
cashed125124353ca__shed
daisied93410013da_isied
damasked1643753damasked
danishes121710493danishes
dashed115920563da__shed
demised113613683demis_ed
dished114318713__dished
enmeshed1444163enmeshed
evanished1644323evanished
failed105421603fa_i_led
fainted114211723fa_inted
faired105915773fa_i_red
famed115928343fam___ed
families1339443families
famine114318193fami_ne_
famines123216263fami_nes
famishing1845233famishing
famishment2054543famishment
fashes124524023fa__shes
fasted105320953fa__sted
fatigued1342943fatigued
fetishes1437153fetishes
finisher1436303finisher
finishes1438983finishes
fisher124917143f__isher
fishes125221343f__ishes
fisted104218703f__isted
flashed144112183f_lashed
flemishes1765243flemishes
fleshed143210263f_leshed
flushed143310973f_lushed
foisted113210603f_oisted
freshed143312593f_reshed
frisked15478823f_risked
furbished1843773furbished
furnished1644583furnished
galoshed1334473galoshed
gamashes1456943gamashes
garnished14196143garnished
gashed116321973ga__shed
hashed136021943ha__shed
immeshed1643433immeshed
inmeshed1444483inmeshed
lamister1037653lamister
lashed105625213la__shed
lavisher1445083lavisher
lavishes1457403lavishes
marishes13512553marishes
mashed125325043__mashed
meshed124415933__meshed
miched143913393__miched
minished1437873minished
misfed124113023__misfed
misled94719313__misled
missed94423603__missed
misted93625823__misted
monished1438133monished
moshed124517493__moshed
mushed124420843__mushed
parishes13314753parishes
pashed125923143pa__shed
perished14310073perished
pished124817063__pished
planished1566123planished
polished1468433polished
punished1436043punished
radishes1269463radishes
raised76120333ra_is_ed
ramified1438043ramified
ravisher1465463ravisher
ravishes1478043ravishes
relished1239433relished
remised103516843remis_ed
samisen937673samis_en
sashed105622943sa__shed
smashed133711223_smashed
smushed13368233_smushed
squished21186393squished
swished14418843_swished
tamises92715973tamis_es
tarnished13196063tarnished
unfished15218293unfished
unmeshed1437003unmeshed
unwished15237833unwished
vamosed1335923vamos_ed
vanisher14167453vanisher
vanishes141610753vanishes
varnished16195603varnished
waisted114210943wa_isted
wampishes1944303wampishes
washed135521503wa__shed
whished17428023_whished
wished134417513__wished

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.1561145455.1
2DLD Change Limit1461621257.31319986.6
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.51523777.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.