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

241 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
polishes1371178(None) 
polished1468431polished
polisher1388071polisher
polishers1477601polishers
abolishes1446052abolishes
depolishes1694122depolishes
goloshes1236252goloshes
monishes13311482monishes
parishes13314752parishes
pelisses1048482pelisses
perishes13313752perishes
pishes114722102p__ishes
plashes124417392p_lashes
plisses94411772p_lisses
plushes124313672p_lushes
poises84226542po_is_es
polices113118052poli_ces
policies122415662policies
polies84034582poli__es
polish114916722polish__
polities102722342polities
potashes1337832potashes
potiches1539202potiches
publishes1645932publishes
punishes1338112punishes
relishes11311952relishes
repolishes15105102repolishes
abolished1544273abolished
abolisher1443723abolisher
abolishers1543183abolishers
banishes131812463banishes
blisses94911513_blisses
blushes124314823_blushes
bolases93315003bolas_es
bolides10515073boli_des
bolshies1338693bol_shies
boluses94113833bolus_es
boshes114721883bo__shes
boxfishes2444153boxfishes
calashes13310533calashes
caliches153812263caliches
clashes124017283_clashes
cliches144213743_cliches
coalfishes1844693coalfishes
codfishes1845643codfishes
cohoshes1635883cohoshes
colies84837053coli__es
coshes115022783co__shes
coulisses1145633coulisses
cowfishes2045723cowfishes
cuishes122810823_cuishes
danishes121710493danishes
demolishes1684903demolishes
depolished17103613depolished
dishes104622653__dishes
dogfishes1745083dogfishes
englishes1345103englishes
eoliths10318573eolith_s
famishes1658283famishes
fetishes1437153fetishes
finishes1438983finishes
fishes125221343__fishes
flashes133916103_flashes
fleshes133913273_fleshes
flushes134114143_flushes
foliages1247623foliages
foliates11412753foliates
foolfishes1943763foolfishes
foolisher1544223foolisher
foolishest1643853foolishest
foxfishes2544053foxfishes
galoshes1236893galoshes
goldfishes1863563goldfishes
goloshe1134723goloshe_
goulashes1343713goulashes
hogfishes1944683hogfishes
hoises94823673ho_is_es
holies94630033holi__es
holisms123811113holis_ms
holists104413963holis_ts
idolises938763idolis_es
iodises83413633iodis_es
iolites73819483ioli_tes
ionises72916433ionis_es
joshes165114853jo__shes
knishes1438263_knishes
lashes94831003__lashes
lavishes1457403lavishes
liches114724293__liches
lisles63416283__lisles
lorises73918593loris_es
lushes94022743__lushes
marishes13512553marishes
minishes13310583minishes
modistes1138643modistes
molasses1037233molasses
molies84429513moli__es
monished1438133monished
moshes115222873mo__shes
noises65021853no_is_es
noshes96618233no__shes
nourishes12116733nourishes
olives94313953_oli_ves
oolites72817843ooli_tes
ooliths10268323oolith_s
orishas1036473_orishas
palisades1245613palisades
palish114718273palish__
palsies94420273pal_sies
panfishes1737593panfishes
parises94827183paris_es
pashes115828393p__ashes
pavises125315493pavis_es
pavisses13397103pavisses
peises84125043p_eis_es
pelisse967063pelisse_
pelites93821993peli_tes
pelvises1337273pelvis_es
penises9318193penis_es
perished14310073perished
pigfishes1845003pigfishes
pinfishes1746243pinfishes
pished124817063p__ished
pisher114317753p__isher
pishers123815753p__ishers
pisses84525083p__isses
pistes85325633p__istes
planishes14138523planishes
plashed133712643p_lashed
plasher124215033p_lasher
plashers133813453p_lashers
plenishes1487083plenishes
plies74526513p_li__es
plights13299313p_lights
pliskies1475973p_liskies
plisse8368403p_lisse_
ploidies1138173ploidies
plosives1335893plosives
pluses83618073p_lus_es
plusher124010383p_lusher
plushest13328283p_lushest
plusses93510693p_lusses
poaches144416943po_aches
podites103014733podi_tes
poesies93217403po_esies
poetises10313953poetis_es
pogies94123543pogi__es
pointes93216753po_intes
poise75127893po_is_e_
poised94918473po_is_ed
poiser84217243po_is_er
poisers94214433po_isers
poisha1135723po_ish_a
poisons9310353po_isons
pokies125921333poki__es
polarises11514073polaris_es
poleaxes1767273poleaxes
poles75351003pol___es
police102918563poli_ce_
policed123212233poli_ced
policer113112683poli_cer
policers12259993policers
polios84019723poli__os
polis74731163poli___s
polishing1536923polishing
polite83625073poli_te_
politer92417073poli_ter
politesses1245363politesses
politest10312943poli_test
politics122513813politics
pollees93215333pol_lees
pollices12410753pollices
pollists10910823pollis_ts
pollster1037103pollster
pollsters1137173pollsters
pollutes1037613pollutes
poloists10910523polois_ts
polyenes13510063polyenes
polysomes1647373polysomes
ponies84833463poni__es
pooches143214163po_oches
poolsides1254553poolsides
popish133812113popish__
popishly1844193popishly
popsies112816463po_psies
porches143815673po_rches
porisms113713453poris_ms
poses74642763po__s_es
posher115018163po__sher
poshest12312423po__shest
posies84431433po__sies
posses85128803po__sses
postiches1648223postiches
potiche1438043potiche_
potlaches16115263potlaches
potlines10714213potli_nes
potsies93019483po_tsies
pouches144116743po_uches
poussies1038113poussies
praises94121103prais_es
prises84133173p_ris_es
prisses94816713p_risses
proclises1339543proclis_es
prolines102619693proli_nes
promisees13246863promisees
promises122916763promis_es
provisoes1446653provisoes
published1744343published
publisher1644213publisher
publishers1743523publishers
puisnes937423p_uisnes
pulses83818663pul_s_es
punished1436043punished
punisher1335773punisher
punishers1434973punishers
pupfishes1944313pupfishes
pushes114621663p__ushes
radishes1269463radishes
ravishes1478043ravishes
relished1239433relished
repolished16114493repolished
slashes103619103_slashes
sloshes103811803_sloshes
slushes103514413_slushes
splashes1337503splashes
sploshes1336133sploshes
spoliates1138543spoliates
squishes20198393squishes
stonishes1247363stonishes
swishes133411373_swishes
toshes94520103to__shes
unlashes11238043unlashes
unpolished1643433unpolished
unwishes14147483unwishes
valises103516263valis_es
vanishes141610753vanishes
welshes13379093wel_shes
whishes16309443_whishes
wishes124920953__wishes
wolffishes2242983wolffishes
wooshes13169883wo_oshes

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 Limit1461622417.39019778.3
3Display Results2412410.0932591.4
 (SQL Overall)1786912417.63923391.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.