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

220 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
guessing103624(None) 
guesting1058461guesting
blessing1137592blessing
bussing103614622bu_ssing
cessing103814812_cessing
cussing103814272cu_ssing
dressing102810422dressing
egressing1146852egressing
fessing113812862_fessing
fussing113611682fu_ssing
gassing94216332g_assing
glassing10329972glassing
glossing10278882glossing
grassing103311972grassing
greasing102811392greasing
grossing103111062grossing
guising93511412gu_ising
gushing124014222gu_shing
gussying1334062gussying
gusting93917162gu_sting
jessing153710622_jessing
messing103916392_messing
mussing104015542mu_ssing
pressing112516442pressing
questing1838272questing
sussing84013702su_ssing
yessing113210062_yessing
accessing1445833accessing
aggressing1344183aggressing
amassing1138003amassing
assessing1045173assessing
beeswing14255763beeswing
besting104923923_besting
biassing11307263biassing
blessings1233723blessings
blissing1136873blissing
bossing103714603_bossing
brassing112612303brassing
bursting1138703bursting
bushing134018583bu_shing
busing96420593bu__sing
busking144116573bu_sking
bussings11386663bu_ssings
busting104221793bu_sting
busying134211993bu_sying
caressing1238803caressing
ceasing104118263_ceasing
censing104215263_censing
cheesing14349413cheesing
classing113211793classing
creasing113314443creasing
cresting114017043cresting
crossing112612683crossing
cueing94913613cue__ing
cursing104217033cu_rsing
digressing1345793digressing
dissing94517683_dissing
dossing93313273_dossing
dressings11265373dressings
dueling93614543due_ling
duelling103410733duelling
dueting93814393due_ting
duetting1047183duetting
dusking133912053du_sking
dusting93618993du_sting
easing74926463__easing
egesting1039013egesting
excessing1945713excessing
feasing113916653_feasing
finessing1345123finessing
flensing1246973flensing
fleshing15339303fleshing
flossing12247903flossing
freshing152611023freshing
fueling113615133fue_ling
fuelling123410153fuelling
fusing104415953fu__sing
gaeing84617223gae__ing
gashing125119233g_ashing
gasking134415913g_asking
gasping113714363g_asping
gassings10438403g_assings
gasting95022763g_asting
gearing92818843g_earing
gecking154111363g_ecking
geeing84313763g_e_eing
gelding103911793g_elding
gelling93219763g_elling
gemming13289143g_emming
genseng933983g_enseng
getting93316563g_etting
ghosting1336463ghosting
gieing83614853gie__ing
gipsying1533373gipsying
glassine9329313glassine
gleaming12277933gleaming
gleaning10269323gleaning
gleeking14316493gleeking
gleeting10279173gleeting
gleying12318433gle_ying
glossina9275543glossina
glueing9338713glue__ing
gnashing1336423gnashing
goosing93314083g_oosing
gosling93312403g_osling
grasping12348833grasping
greeing93613783gre_eing
greening103112533greening
greeting103112353greeting
greying124110893gre_ying
grousing103410453grousing
grueling1078273grue_ling
gruelling1155603gruelling
guarding1136523guarding
guess64213363guess___
guessed9176603guess_ed
guesser8166543guess_er
guessers9174903guessers
guesses8169373guess_es
guggling10236353guggling
guiding102911843gu_iding
guiling93214213gu_iling
gulfing12339473gu_lfing
gulling94019563gu_lling
gullwing13304923gullwing
gullying13367243gullying
gulping11309753gu_lping
gumming133810193gu_mming
gunning93413173gu_nning
gurging102910113gu_rging
gurgling11267323gurgling
gusseting1173963gusseting
gussie72910153gu_ssi_e
gussied9267193gu_ssied
gussies82813303gu_ssies
gutting93415923gu_tting
guttling1037293guttling
guying11379723gu__ying
guzzling18225063guzzling
gypsying1842183gypsying
hissing114213143_hissing
hushing144514473hu_shing
husking154312053hu_sking
jesting154317713_jesting
justing153615163ju_sting
kissing122911053_kissing
leasing83920163_leasing
lensing84015103_lensing
lushing114316113lu_shing
lusting83619323lu_sting
massing104318023_massing
mensing103915103_mensing
meshing134513813_meshing
misguessing1542833misguessing
missing103619073_missing
mossing103915423_mossing
moussing1138143moussing
mushing134217633mu_shing
musing93919503mu__sing
musting103221073mu_sting
nesting84320443_nesting
nursing84012553nu_rsing
nursling997603nursling
obsessing1244263obsessing
ousting84021353ou_sting
outguessing1342773outguessing
outsing83320463ou_tsing
outswing1259283outswing
passing104318423_passing
peising103416763_peising
pissing103914803_pissing
pleasing112611593pleasing
pressings12269023pressings
prissing113011453prissing
pulsing103712863pu_lsing
pursing103715553pu_rsing
pursuing1146233pursuing
pushing133615453pu_shing
quashing2137093quashing
quassin1645943quassin_
quassins1735793quassins
queening1846113queening
queering1838203queering
quelling18259793quelling
querying2135243querying
queueing1842873queueing
queuing1736233que_uing
quisling18218063quisling
recessing12611013recessing
reesting93118273reesting
regressing1248143regressing
resting85031183_resting
reusing82516783_reusing
riesling939013riesling
rushing113817703ru_shing
rusting83821263ru_sting
sassing84615553_sassing
seising84018863_seising
sensing84116953_sensing
stressing1038333stressing
sudsing92910323su_dsing
sueding92613753sue_ding
teasing83918513_teasing
tensing84616653_tensing
testing86021053_testing
tossing83612563_tossing
trussing9268653trussing
tumescing1443643tumescing
tushing114214013tu_shing
tusking124212063tu_sking
tussling935823tussling
unsling8313643_unsling
upswing1335593_upswing
using66317963_u__sing
versing112314193_versing
vesting114618683_vesting
westing115020273_westing
wissing113212943_wissing
wresting123811833wresting
zesting174515333_zesting

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 Filter1786911461620.440406115.9
2DLD Change Limit1461622207.26620115.9
3Display Results2202200.0762894.7
 (SQL Overall)1786912207.78222962.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.