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

111 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
polishing153692(None) 
abolishing1644232abolishing
depolishing1843502depolishing
monishing1547542monishing
perishing1539532perishing
pishing134314372p__ishing
plashing143311062p_lashing
poising103617102po_is_ing
policing13311672poli_cing
publishing1844002publishing
punishing1545382punishing
relishing13229182relishing
repolishing1744582repolishing
banishing1537143banishing
blissing1136873_blissing
blushing14339333_blushing
clashing143812193_clashing
colistin10410553colistin_
colistins1149223colistins
coshing134316433co__shing
delisting112710503delisting
demolishing1843883demolishing
dishing124017103__dishing
englishing1543873englishing
enlisting1038343enlisting
famishing1845233famishing
finishing1645843finishing
fishing143913863__fishing
flashing153711553_flashing
fleshing15339303_fleshing
flushing15288833_flushing
foisting122910503fo_isting
foliating1339253foliating
folioing1237573foli_oing
hoising113414413ho_is_ing
hoisting123610903ho_isting
idolising1145893idolis_ing
iodising1037563iodis_ing
ionising9310223ionis_ing
joisting16328503jo_isting
joshing18519413jo__shing
lashing114422893__lashing
lavishing1644553lavishing
lisping103412753__lisping
listing84020593__listing
lushing114316113__lushing
minishing1547073minishing
molesting1237753molesting
moshing134214883mo__shing
noising83615173no_is_ing
noshing114612773no__shing
nourishing1444243nourishing
palisading1443893palisading
palsying1436233pal_sying
pashing135120513p__ashing
peising103416763p_eis_ing
pissing103914803p__issing
pithing134014053p__ithing
planishing1645323planishing
plenishing1644693plenishing
plighting1635563p_lighting
plinking153611243p_linking
ploughing16203673ploughing
poaching163510833po_aching
poetising1238713poetis_ing
poinding122510003po_inding
pointing112813683po_inting
poisoning1245903po_isoning
polarising1347663polaris_ing
poleaxing1944873poleaxing
poling93526503pol___ing
polish114916723polish___
polished1468433polish_ed
polisher1388073polish_er
polishers1477603polishers
polishes13711783polish_es
polkaing1534633pol_kaing
pollening1236923pollening
polling102920383pol__ling
polluting1235703polluting
pooching16328983po_oching
poohing133112323po__ohing
posing93922643po__s_ing
positing11312303posi_ting
posting105622243po__sting
pouching163210413po_uching
praising113214563prais_ing
prising103321453p_ris_ing
prissing113011453p_rissing
promising14410973promis_ing
publishings1951843publishings
pulsing103712863pul_s_ing
pushing133615453p__ushing
ravishing1634983ravishing
relisting102414353relisting
slashing123713413_slashing
sloshing12258823_sloshing
slushing12299643_slushing
splashing1535703splashing
sploshing1544293sploshing
spoliating1366963spoliating
squishing2234953squishing
stonishing1444913stonishing
swishing15277813_swishing
unlashing1336493unlashing
unwishing1635593unwishing
vanishing1646303vanishing
welshing15296523wel_shing
whishing18287183_whishing
wishing144114893__wishing
wooshing1536683wo_oshing

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411116.53322752.3
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.01525472.7
 
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.