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

195 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
cleanser1035632(None) 
cleaner93712301clean_er
cleanse9358721cleanse_
cleansed11395931cleansed
cleansers11335071cleansers
cleanses10358141cleanses
censer84516582c_e_nser
clanger104113492cl_anger
classer93614612cl_asser
cleaned103512002clean_ed
cleaners103610542clean_ers
cleanest10310292cleanest
cleanlier1143362cleanlier
cleans85817052cleans__
clearer93710822clea_rer
cleaver124110802clea_ver
creaser94415742crea_ser
flenser1036782fle_nser
gleaner8379772glean_er
leaner64022192_lean_er
leaser65322672_lea_ser
oleander936402oleander
pleaser93912342plea_ser
alexander1742773alexander
blander103715163bl_ander
blanker134612023bl_anker
bleacher15358883bleacher
bleaker133510533blea_ker
blearier1037333blearier
bleater94515303blea_ter
blender104613843ble_nder
blesser9329293ble_sser
calender1138273cale_nder
cancer104220923c__ancer
caner75334773c__an_er
canker124422523c__anker
canner84625983c__anner
canoer85121073c__anoer
canter85230113c__anter
causer84117783c__auser
cease75227653c_ea_se_
ceased94920783c_ea_sed
ceases84427073c_ea_ses
cense75121403c_e_nse_
censed94016323c_e_nsed
censers94313903c_e_nsers
censes83721803c_e_nses
censor84011293c_e_nsor
center84421413c_e_nter
chancer144215633c_hancer
changer134215543c_hanger
chanter123919733c_hanter
chaser114918383c_ha_ser
cheaper144010583chea_per
cheater124816963chea_ter
clabber134210113cl_abber
clacker153813773cl_acker
claimer11279883cl_aimer
clamber133311743cl_amber
clammer134211793cl_ammer
clamper134012993cl_amper
clanged114212653cl_anged
clangers114312343cl_angers
clangor10426683cl_angor
clanked143812253cl_anked
clankier14327083cl_ankier
clans75031013cl_ans__
clansmen1245723cl_ansmen
clapper134011863cl_apper
claquer18287353cl_aquer
clasher124615513cl_asher
clasper113811863cl_asper
classed104113653cl_assed
classers104111833cl_assers
classes94717943cl_asses
classier10359083cl_assier
clatter94014973cl_atter
clause84311503cl_ause_
clauses93813323cl_auses
claver113816973cl_a_ver
clavier1239173cl_avier
clawer114512783cl_a_wer
clayier1248323cl_ayier
clean75420413clean___
cleaning113112383cleaning
cleanly1236323clean_ly
cleanness1144973cleanness
cleansing1235073cleansing
cleanup1144083clean_up
cleanups1242203cleanups
clear76219053clea___r
cleared103612463clea_red
clearers10349303clea_rers
clearest1038653clearest
clearness1135633clearness
clears84116563clears__
cleated103417843clea_ted
cleats84919313cleats__
cleave114212513clea_ve_
cleaved134010483clea_ved
cleavers13398873clea_vers
cleaves124111623clea_ves
clencher15277973clencher
clever114611533cle__ver
cleverer1334563cleverer
clevises1336903clevises
clinger103812153cl_inger
clinker133811663cl_inker
cloner84418093cl_on_er
closer84918203cl__oser
clunker13419453cl_unker
coarser93211203c_oarser
colander1139033colander
coleader1139183colea_der
cranker133612793c_ranker
crasser94114343c_rasser
creakier14328333creakier
creamer113714093crea_mer
creamier12319063creamier
crease85519573crea_se_
creased104315583crea_sed
creasers103612843crea_sers
creases94020963crea_ses
creasier103210193creasier
denser74115193_de_nser
flanger113412623fl_anger
flanker143911293fl_anker
flense938903fle_nse_
flensed1136613fle_nsed
flensers1135463fle_nsers
flenses1039473fle_nses
glancer103710073gl_ancer
gleamer10328513glea_mer
gleamier1144913gleamier
gleaned9349423glean_ed
gleaners9348073glean_ers
gleans75014743gleans__
greaser83913083grea_ser
lancer84319973_l_ancer
lander74028483_l_ander
lanker104123003_l_anker
lanner64920603_l_anner
lapser84113143_l_apser
laser54633323_l_a_ser
leacher124014843_leacher
leader74824653_lea_der
leadier83212723_leadier
leafier10329833_leafier
leaguer835793_leaguer
leaker104620073_lea_ker
leakier114010993_leakier
leaned73422543_lean_ed
leaners73718173_lean_ers
leanest7415863_leanest
leans55536253_leans__
leaper88118943_lea_per
learier73415663_learier
learner7319383_learner
lease55230263_lea_se_
leased74722883_lea_sed
leasers74717843_lea_sers
leases65428113_lea_ses
leather103815783_leather
leaver94321513_lea_ver
leavier10319993_leavier
lender73921273_le_nder
lense54523433_le_nse_
lensed74015473_le_nsed
lenses64620893_le_nses
lesser63514853_le_sser
levanter1145303_levanter
loaner64416503_loan_er
meander1049973_meander
meaner84617843_mean_er
oleanders1035573oleanders
oleaster837263oleaster
planer84122653pl_an_er
planner93511623pl_anner
planter94017803pl_anter
pleader103511753plea_der
please84315733plea_se_
pleased103712073plea_sed
pleasers104010293plea_sers
pleases94515483plea_ses
pleater93916333plea_ter
pleather1356653pleather
relapser1035273relapser
releaser839503relea_ser
slander84015443sl_ander
sleazier1735123sleazier
slender83413593sle_nder
teaser65421523_tea_ser
tenser64919433_te_nser
uncleaner1144763unclean_er
weaner93816773_wean_er

Search took 9 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.470380193.6
2DLD Change Limit1461621957.56319325.9
3Display Results1951950.0762565.8
 (SQL Overall)1786911958.10922036.1
 
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.