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

195 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
famishes165828(None) 
famished1766021famished
banishes131812462banishes
camises114218462camis_es
danishes121710492danishes
families1339442families
famines123216262fami_nes
famish14311842famish__
fashes124524022fa__shes
fetishes1437152fetishes
finishes1438982finishes
fishes125221342f__ishes
flemishes1765242flemishes
gamashes1456952gamashes
lavishes1457402lavishes
marishes13512552marishes
parishes13314752parishes
radishes1269462radishes
ravishes1478042ravishes
tamises92715972tamis_es
vanishes141610752vanishes
wampishes1944302wampishes
abashes12510373_abashes
affiches1945233affiches
aisles64721143_a_isles
amasses93912853_amasses
ambushes1535803_ambushes
amices105018013_ami_ces
amides95722663_ami_des
amies76837693_ami__es
amines84727983_ami_nes
amiss75823073_amis__s
amities9317383_amities
amuses85117943_amus_es
anises64826693_anis_es
arises65233803_aris_es
ashes86230613_a__shes
axises134413993_axis_es
babiches1735253babiches
banished14189063banished
banisher13169183banisher
banishers14258053banishers
bashes115631393ba__shes
batfishes1746583batfishes
batistes1039713batistes
blemishes1665083blemishes
calashes13310543calashes
caliches153812273caliches
camases114216343camas_es
camasses12388973camasses
camisades1474963camisades
camisas113411923camis_as
camise103319633camis_e_
camisias12268603camisias
camisoles1345583camisoles
cashes114729883ca__shes
catfishes1746303catfishes
chamises153513313chamis_es
cuishes122810823_cuishes
daises74318983da_is_es
daisies84217093da_isies
dashes106124983da__shes
demises103719563demis_es
dishes104622653__dishes
enmeshes1345343enmeshes
evanishes1545603evanishes
facies113921593faci__es
failles102914133fa_illes
fairies103516043fa_iries
faithed1437163fa_ithed
faiths124610273fa_ith_s
fallfishes1943983fallfishes
falsies103515013fa_lsies
fames105735923fam___es
famine114318193fami_ne_
famishing1845233famishing
famishment2054543famishment
famishments2153383famishments
farinhas14325363farinhas
farsides1237993farsides
fasces114914543fa__sces
fashed136720253fa__shed
fatigues1244193fatigues
fatsoes10379423fa_tsoes
favisms1535443favis_ms
favuses1336183favus_es
fetiches1636953fetiches
fiches145219533f__iches
finfishes1846043finfishes
finises10312903finis_es
finished1536483finished
finisher1436303finisher
finishers1545353finishers
fished134316313f__ished
fisher124917143f__isher
fishers134714723f__ishers
flamines13311643flami_nes
flashes133916103f_lashes
flatfishes1944003flatfishes
flemished1853633flemished
fleshes133913273f_leshes
flimsies1335783flimsies
flushes134114143f_lushes
fomites123613203fomi_tes
foxfishes2544053foxfishes
fraises104215693frais_es
freshes133515823f_reshes
frisees104411693f_risees
frises94124273f_ris_es
furbishes1745243furbishes
furnishes1536233furnishes
galoshes1236913galoshes
gamines103618463gami_nes
garfishes16167083garfishes
garnishes13198813garnishes
gashes105725153ga__shes
hagfishes1945153hagfishes
hashes125024803ha__shes
hashishes1444393hashishes
immeshes1543933immeshes
inmeshes1345613inmeshes
kaddishes1844093kaddishes
knishes1438263_knishes
kumisses1443583kumisses
lamister1037653lamister
lamisters1157123lamisters
lapises93513463lapis_es
lashes94831003la__shes
lavashes1445573lavashes
lavished1555133lavished
lavisher1445083lavisher
lavishers1564643lavishers
lavishest1554883lavishest
mamies104626243mami__es
marshes123615373ma_rshes
mashes115030003__mashes
mavises122812993mavis_es
meshes115019443__meshes
miches134320733__miches
minishes13310583minishes
mises74740563__mis_es
misses85130873__misses
monishes13311483monishes
moshes115222873__moshes
mushes114124563__mushes
oarfishes15156953oarfishes
panfishes1737593panfishes
parises94827183paris_es
pashes115828393pa__shes
pavises125315493pavis_es
pavisses13397103pavisses
perishes13313753perishes
pishes114722103__pishes
planishes14138523planishes
polishes13711783polishes
punishes1338113punishes
quamashes2343973quamashes
raises64826543ra_is_es
ramies84630463rami__es
ramifies13310503ramifies
ramilies10311833ramilies
rashes95330153ra__shes
ratfishes1546103ratfishes
ravished1555713ravished
ravisher1465463ravisher
ravishers1564783ravishers
relishes11311953relishes
remises93423483remis_es
samisen937673samis_en
samisens1035483samisens
samites93118713sami_tes
samshus12125353sam_shus
sashes94728483sa__shes
sawfishes1845743sawfishes
semises93916553semis_es
smashes123914613_smashes
smushes123710093_smushes
squishes20198393squishes
swishes133411373_swishes
tamashas13135683tamashas
tapises92914013tapis_es
tarnishes12188893tarnishes
unmeshes1346153unmeshes
unwishes14147483unwishes
valises103516263valis_es
vamoses1239143vamos_es
vanished15207743vanished
vanisher14167453vanisher
vanishers15186613vanishers
varnishes15207913varnishes
wampished2042803wampished
wamuses1237023wamus_es
washes124425493wa__shes
whishes16309443_whishes
wishes124920953__wishes

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.420425454.8
2DLD Change Limit1461621956.42322756.0
3Display Results1951950.0802437.5
 (SQL Overall)1786911956.92325811.2
 
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.