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

172 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
fetishes143715(None) 
fetiches1636951fetiches
betises94816122betis_es
famishes1658282famishes
fetches153413892fet_ches
fetiales11319612fetiales
fetish12310372fetish__
fetishism1752262fetishism
fetishist1543712fetishist
fetishizes2552092fetishizes
fetuses10310242fetus_es
finishes1438982finishes
fishes125221342f__ishes
flemishes1765242flemishes
metisses1036832metisses
perishes13313752perishes
relishes11311952relishes
aegises8311373aegis_es
artistes83213343artistes
banishes131812463banishes
batfishes1746583batfishes
batistes1039713batistes
bekisses1434243bekisses
betides104915263beti_des
betimes115114413beti_mes
betise85616273betis_e_
blemishes1665083blemishes
catfishes1746303catfishes
cerises94722253ceris_es
ceviches1834843ceviches
cherishes1767563cherishes
cuishes122810823_cuishes
cutises94414913cutis_es
danishes121710493danishes
deashes113313903de_ashes
dehisces1464713dehisces
demises103719563demis_es
dervishes1644933dervishes
detaches1439653detaches
detinues9569823detinues
devisees12358283devisees
devises114116763devis_es
dishes104622653__dishes
egises7312493_egis_es
enisles72312603_enisles
etches114217763_et_ches
famished1766023famished
fashes124524023f__ashes
fatigues1244193fatigues
fatsoes10379423fat_soes
feases95422923fe_as_es
feists94915313fe_is_ts
feldsher1543243feldsher
feldshers1643093feldshers
felines104718073feli_nes
felsites1138073felsites
ferities111416713ferities
fesses94820253fe__sses
fetched163710473fet_ched
fetcher153510393fet_cher
fetchers16328863fet_chers
fetes85630143fet___es
fetialis11358663fetialis
fetials103711743feti_als
fetich1479693fetich__
fetichism1943663fetichism
feticides1547003feticides
fetidness1345443fetidness
fetishisms1852483fetishisms
fetishists1652303fetishists
fetishize2442393fetishize
fetishized2651903fetishized
fettles103912733fet_tles
fiches145219533f__iches
filefishes1944483filefishes
finfishes1846043finfishes
finises10312903finis_es
finished1536483finished
finisher1436303finisher
finishers1545353finishers
fished134316313f__ished
fisher124917143f__isher
fishers134714723f__ishers
fitches153516193fit_ches
flashes133916103f_lashes
flatfishes1944003flatfishes
flemished1853633flemished
fleshes133913273f_leshes
fletches16308853flet_ches
flitches16388463flitches
flushes134114143f_lushes
foetuses1136083foetus_es
foxfishes2544053foxfishes
fraises104215693frais_es
freshes133515823f_reshes
frisees104411693f_risees
frises94124273f_ris_es
furbishes1745243furbishes
furnishes1536233furnishes
geishas1135083ge_ishas
jewfishes2543383jewfishes
ketches164012193ket_ches
ketoses114912873ketos_es
knishes1438263_knishes
lavishes1457403lavishes
leashes103514403le_ashes
letches124015483let_ches
lethes94818083let__hes
lewises1039133lewis_es
marishes13512553marishes
menshes12310453me_nshes
merises93421423meris_es
meshes115019443me__shes
metisse936503metisse_
minishes13310583minishes
mitises9315543mitis_es
monishes13311483monishes
nebbishes1642973nebbishes
outfishes15118023outfishes
outwishes15126563outwishes
parishes13314753parishes
peises84125043pe_is_es
pelisses1048483pelisses
penises9318193penis_es
perished14310083perished
petioles10311643petioles
petites93820203peti_tes
pishes114722103__pishes
plenishes1487083plenishes
poetises10313953poetis_es
polishes13711783polishes
potashes1337833potashes
potiches1539203potiches
punishes1338113punishes
radishes1269463radishes
ratfishes1546103ratfishes
ravishes1478043ravishes
redfishes1645793redfishes
rehashes1436953rehashes
relished1239433relished
remises93423483remis_es
rerises73525883reris_es
reshes94124363re__shes
retastes82212903retastes
retches123318513ret_ches
reticles103912483reticles
reties65436193reti__es
retiles74426993reti_les
retimes95020173reti_mes
retines75134673reti_nes
retinues85113153retinues
retirees84611653retirees
retires74726213reti_res
retitles83612593retitles
revises104220533revis_es
rewashes1447033rewashes
seiches12513813se_iches
seises64026713se_is_es
semises93916553semis_es
seviches1635803seviches
squishes20198393squishes
stashes103916173_stashes
swishes133411373_swishes
tithes94720213__tithes
toshes94520103__toshes
tushes94319473__tushes
unwishes14147483unwishes
vanishes141610753vanishes
vetches153411263vet_ches
welshes13379093we_lshes
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.406440125.6
2DLD Change Limit1461621726.40622816.4
3Display Results1721720.0762263.2
 (SQL Overall)1786911726.88825942.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.