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

139 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
cleansing123507(None) 
cleaning113112381clean_ing
ceasing104118262c_ea_sing
censing104215262c_e_nsing
clanging124012122cl_anging
clanking154313062cl_anking
classing113211792cl_assing
clearing113014882clea_ring
clearwing1533672clearwing
cleating113518142clea_ting
cleaving141389682clea_ving
creasing113314442crea_sing
flensing1246972fle_nsing
gleaning10269322glean_ing
leaning83721202_lean_ing
leasing83920162_lea_sing
lensing84015102_le_nsing
pleasing112611592plea_sing
aliasing9310073alia_sing
beaning103820683_bean_ing
blanking154411933bl_anking
bleaching17287093bleaching
blearing113111943blea_ring
bleating113514503blea_ting
blending12249963ble_nding
blessing1137593ble_ssing
caning94128623c__an_ing
canning103620133c__anning
canting104725903c__anting
casing94829103c__a_sing
causing103614413c__ausing
celandine1245623celandine
cessing103814813c_e_ssing
chancing162810283c_hancing
changing153211513c_hanging
chanting143413533c_hanting
chasing133715893c_ha_sing
cheating144014523chea_ting
cheesing14349413che_esing
clacking173313493cl_acking
cladding1337143cl_adding
clagging13328883cl_agging
claiming13279303cl_aiming
clamming15329373cl_amming
clamping154011153cl_amping
clapping153810603cl_apping
clashing143812193cl_ashing
clasping133310263cl_asping
clawing133812673cl_a_wing
claying133614303cl_a_ying
cleanlier1143363cleanlier
cleans85817053cleans___
cleanse9358723cleans__e
cleansed11395933cleans_ed
cleanser10356323cleans_er
cleansers11335073cleansers
cleanses10358143cleans_es
clearings12286063clea_rings
clearwings1651703clearwings
cleeking15267813cle_eking
clefting14347583cle_fting
clenching17266303clenching
cleping123310423cle__ping
clerking15257163cle_rking
clewing13359583cle__wing
clinging122910913cl_inging
clinking153611663cl_inking
cloaking15299713cloa_king
cloning103215473cl_on_ing
clonking153810153cl_onking
closing103114843cl__osing
clowning14307253clown_ing
clunking15329433cl_unking
coleading1338523colea_ding
collapsing1543833collapsing
craning103620303c_ran_ing
cranking154613073c_ranking
creaking153414123crea_king
creaming133413143crea_ming
creating113921953crea_ting
crevassing1643533crevassing
deaning94020473_dean_ing
eanling81416673__eanling
easing74926463__ea_sing
elapsing1146713el_apsing
elegising1145423elegising
feasing113916653_fea_sing
flanging132710583fl_anging
flanking164211083fl_anking
glancing1247063gl_ancing
glassing10329973gl_assing
gleaming12277933glea_ming
gleanings11244643glean_ings
greasing102811393grea_sing
hearsing1239383_hearsing
lancing103314123_l_ancing
landing92819323_l_anding
lapsing103511163_l_apsing
lasing74727983_l_a_sing
leaching143012833_leaching
leading93419553_lea_ding
leafing113313583_lea_fing
leaguing1035343_leaguing
leaking123616973_lea_king
leanings94010183_lean_ings
leaping103215993_lea_ping
learning978553_learning
leashing123310313_leashing
leasings9379843_lea_sings
leaving114216853_lea_ving
lending94118533_le_nding
levanting1345523_levanting
liaising937913_liaising
loaning83614833_loan_ing
meaning103918703_mean_ing
mensing103915103_me_nsing
planing103418253pl_an_ing
planking153513013pl_anking
planning113610223pl_anning
planting113515383pl_anting
pleaching17257083pleaching
pleading123011443plea_ding
pleating112916053plea_ting
recleaning1336753reclean_ing
relanding112110923relanding
relapsing1236843relapsing
releasing10411013relea_sing
sclerosing1343693sclerosing
sensing84116953_se_nsing
slanging103413433sl_anging
slanting94115093sl_anting
sleaving123310983slea_ving
speaning113512243spean_ing
teasing83918513_tea_sing
tensing84616653_te_nsing
weaning114117193_wean_ing
weanling12118643_weanling
yeaning113814633_yean_ing
yeanling12107063_yeanling

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.423422437.4
2DLD Change Limit1486411397.34320242.5
3Display Results1391390.0602316.7
 (SQL Overall)1786911397.82622833.0
 
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.