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

161 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
perishing153953(None) 
cherishing1944832cherishing
peising103416762pe_is_ing
perching163711632per_ching
periling11316862peri_ling
perilling12410002perilling
persisting1346652persisting
perusing11811062perus_ing
pishing134314372p__ishing
plenishing1644692plenishing
polishing1536922polishing
prising103321452p_ris_ing
prissing113011452p_rissing
punishing1545382punishing
relishing13229182relishing
rerising93017782reris_ing
aerifying1636493aerifying
apprising1447963appris_ing
arising83619973_aris_ing
banishing1537143banishing
bekissing1643503bekissing
bemisting1438073bemisting
beriming13310463beri_ming
berthing14209593ber_thing
blemishing1843513blemishing
brisking15329473_brisking
brisling112410843_brisling
brushing14359963_brushing
burnishing1643913burnishing
crashing143512633_crashing
creeshing1536243creeshing
crisping13319663_crisping
crushing143010053_crushing
deashing134210953de_ashing
dehiscing1643733dehiscing
delisting112710503delisting
demising122012523demis_ing
deriding112512933deri_ding
deriving132510743deri_ving
desisting112810383desisting
devising133111523devis_ing
dishing124017103__dishing
enisling949633_enisling
enriching1546153enriching
erasing8317963_eras_ing
existing1639073_existing
famishing1845233famishing
finishing1645843finishing
fishing143913863__fishing
flemishing1943493flemishing
freshing152611023_freshing
frisking16268363_frisking
furbishing1943373furbishing
furnishing1744013furnishing
garnishing1544573garnishing
heisting123411043he_isting
inrushing1365503inrushing
irising83614423_iris_ing
lavishing1644553lavishing
leashing123310313le_ashing
meriting11314683meri_ting
meshing134513813me__shing
minishing1547073minishing
monishing1547543monishing
neighing1355523ne_ighing
nourishing1444243nourishing
onrushing1364813onrushing
overfishing2145853overfishing
parching164313053par_ching
parsing103819553par_s_ing
pashing135120513p__ashing
peaching163613643pe_aching
peching154513903pe__ching
peining104619153pe_i_ning
percussing1545223percussing
perduring1336013perduring
perfuming1784053perfuming
perfusing1565633perfusing
perish114619063perish___
perished14310083perish_ed
perishes13313753perish_es
periwig1345163peri_wi_g
perjuring1944923perjuring
perking143716463per__king
perming123416093per__ming
permitting1546303permitting
permuting1446553permuting
pervading1636303pervading
petrifying1945823petrifying
phrasing1438013phras_ing
pissing103914803p__issing
pithing134014053p__ithing
planishing1645323planishing
plashing143311063p_lashing
poetising1238713poetis_ing
poising103617103p_ois_ing
praising113214563prais_ing
preaching172811163preaching
precising14413273precis_ing
premising14412413premis_ing
prerinsing1347643prerinsing
presiding13510903presiding
pressing112516443p_ressing
prevising15510873previs_ing
prewashing1944943prewashing
pricing123417343p_ri_cing
pricking173212603p_ricking
priding113317543p_ri_ding
priesting1239483p_riesting
prigging13299093p_rigging
prilling113413413p_rilling
priming123417373p_ri_ming
primming15268173p_rimming
primping15338893p_rimping
prinking153212453p_rinking
printing113216083p_rinting
prisoning1237643p_risoning
pristine10313503p_ristine
prizing193514683p_ri_zing
prosing103319383p_ros_ing
publishing1844003publishing
purifying1835853purifying
pursing103715553pur_s_ing
pursuing1146233pur_suing
pushing133615453p__ushing
ravishing1634983ravishing
refreshing1746063refreshing
rehashing1647113rehashing
relisting102414353relisting
remising112516453remis_ing
reprising12312553repris_ing
reraising10313773rerais_ing
rerigging1236553rerigging
resisting103215313resisting
revising122714403revis_ing
rewashing1676903rewashing
rising74025883__ris_ing
risking123914243__risking
rushing113817703__rushing
seising84018863se_is_ing
seriating10916403seriating
spearfishing2151463spearfishing
squishing2234953squishing
swishing15277813_swishing
tarnishing1445153tarnishing
thrashing1635683thrashing
threshing1645663threshing
trashing122613223_trashing
trithing122811773_trithing
unwishing1635593unwishing
uprising1138953upris_ing
uprushing1544043uprushing
vanishing1646303vanishing
varnishing1744473varnishing
verifying1936413verifying
versing112314193ver_s_ing
weighing1635283we_ighing
welshing15296523we_lshing
whishing18287183_whishing
wishing144114893__wishing
writhing15278673_writhing

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 Limit1486411617.43619989.4
3Display Results1611610.0802012.5
 (SQL Overall)1786911617.95222471.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.