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

127 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
creeshing153624(None) 
breeching17236472breeching
cheesing14349412chees_ing
crashing143512632cr_ashing
creasing113314442creas_ing
creeling113513362cree_ling
creeping133310102cree_ping
cresting114017042cr_esting
crushing143010052cr_ushing
freshing152611022fr_eshing
reesting93118272_reesting
screeching1843642screeching
arresting1038633arresting
beeswing14255763_beeswing
breaching17269403breaching
breasting1239583breasting
breathing15218373breathing
breechings18273723breechings
breeding123411843bree_ding
breezing20368133bree_zing
brushing14359963br_ushing
careening12310013caree_ning
careering12311203caree_ring
caressing1238803caressing
cashing135022553c__ashing
ceasing104118263c_eas_ing
censing104215263c_ens_ing
cessing103814813c__essing
cheeking18349083chee_king
cheeping16329553chee_ping
cheering143612703chee_ring
cherishing1944833cherishing
clashing143812193c_lashing
cleeking15267813clee_king
clenching17266303clenching
coshing134316433c__oshing
cranching17278733cranching
creaking153414123cr_eaking
creaming133413143cr_eaming
creating113921953cr_eating
crediting1338843crediting
creesh11328333creesh___
creeshed1435693creesh_ed
creeshes1336953creesh_es
cremating14312193cremating
creneling1247733creneling
crenelling1345683crenelling
creosoting1343793creosoting
creping122913653cr_e_ping
crestings12298043cr_estings
crevassing1643533crevassing
crewing133212633cr_e_wing
crisping13319663cr_isping
crossing112612683cr_ossing
crouching1746383crouching
cruising112610153cruis_ing
crunching17297003crunching
crusting113612793cr_usting
crutching17216073crutching
deashing134210953_deashing
dreeing94311183dree__ing
drenching16256033drenching
dressing102810423dr_essing
enmeshing15114873enmeshing
fleeching18305013fleeching
fleshing15339303_fleshing
freeing113713913free__ing
freezing21308323free_zing
frenching18267753frenching
greasing102811393greas_ing
greeing93613783gree__ing
greening103112533gree_ning
greenling1136753greenling
greenwing1434693greenwing
greeting103112353gree_ting
immeshing17103463immeshing
inmeshing1595333inmeshing
leashing123310313_leashing
leeching14318373_leeching
meshing134513813__meshing
perishing1539533perishing
preaching172811163preaching
precessing1598743precessing
preeing103817673pree__ing
preening113115843pree_ning
pressing112516443pr_essing
pretesting131810683pretesting
prewashing1944943prewashing
priesting1239483priesting
reaching143317203_reaching
recessing12611013_recessing
reechoing1545293_reechoing
reeding94124133_ree_ding
reedling102414273_reedling
reefing114016863_ree_fing
reeking123318643_ree_king
reeling83126863_ree_ling
reeving113717663_ree_ving
refreshing1746063_refreshing
rehashing1647113_rehashing
relishing13229183_relishing
renesting102514703_renesting
reseeing92412623_reseeing
resewing122712263_resewing
reshine102816943_r_eshine
resting85031183_r_esting
retching143412173_retching
retesting102614603_retesting
reusing82516783_reus_ing
revesting132814123_revesting
rewashing1676903_rewashing
riesling939013_riesling
rushing113817703_r_ushing
screeding1336323scree_ding
screening1247193scree_ning
seething1239023_seething
skreeghing1941483skreeghing
teething1237163_teething
threshing1645663threshing
trashing122613223tr_ashing
treeing83414303tree__ing
trenching15227653trenching
unmeshing1595933unmeshing
welshing15296523_welshing
wreathing16266313wreathing
wrenching18276273wrenching
wresting123811833wr_esting

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.453394461.4
2DLD Change Limit1486411276.90321532.8
3Display Results1271270.0632015.9
 (SQL Overall)1786911277.41924085.6
 
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.