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

128 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
snoozled1834449(None) 
snooled84513941snoo_led
snoozed173410131snooz_ed
snoozle16305911snoozle_
snoozles17335561snoozles
foozled20346892_foozled
noodled9339922_noodled
shooled115212662shoo_led
snooded94110362snoo_ded
snooked123711492snoo_ked
snooped103711812snoo_ped
snooted84213282snoo_ted
snooze15439992snooz_e_
snoozer16409192snooz_er
snoozes16289782snooz_es
snoozier17185192snoozier
sozzled16265182s_ozzled
spooled104613522spoo_led
stooled84313892stoo_led
boodled113410933_boodled
boozed184813833_booz_ed
canoodled1342803canoodled
cooled95224593_coo_led
doodled10369463_doodled
drooled9369203droo_led
ennobled1143833ennobled
enrolled967963enrolled
ensouled935833ensouled
entoiled968283entoiled
fooled104317823_foo_led
footled113610763_footled
foozle18369203_foozle_
foozler19397593_foozler
foozles19329543_foozles
insouled936113insouled
knolled12296573kn_olled
monocled1337113monocled
nobbled123511283_nobbled
noddled10358563_noddled
noodged10295933_noodged
noodle73212543_noodle_
noodles83513193_noodles
noosed75018013_noo_sed
nozzle14236633_nozzle_
nozzles15276303_nozzles
nuzzled16276393_nuzzled
oozed154214263__ooz_ed
pooled94619813_poo_led
rootled83410533_rootled
schooled1447053schooled
scooched16206683scooched
scooped124611743scoo_ped
scooted103612283scoo_ted
scowled13398193s_cowled
scrolled1137053scrolled
shmoozed23254363shmooz_ed
shoaled113810973s_hoaled
shooed103916083shoo__ed
shoveled15195353shoveled
sizzled16367883s_izzled
skoaled12226063s_koaled
smooched16185983smooched
smooshed14185993smooshed
smoothed14236473smoothed
snaffled15285213snaffled
snailed83811923sn_ailed
snarled83612363sn_arled
sneezed17287793sneez_ed
snelled83313053sn_elled
sniffled15276443sniffled
sniggled11275743sniggled
sniveled1255463sniveled
snogged10417973sn_ogged
snood64616163snoo___d
snooker113910303snoo_ker
snookered1443263snookered
snool55118643snoo_l__
snools65715883snoo_l_s
snooper93511533snoo_per
snoopier10177273snoopier
snootier8278383snootier
snoozers17296943snoozers
snooziest18175393snooziest
snoozing18319083snoozing
snoozling19314343snoozling
snoozy18517233snooz__y
snored74819543sn_o_red
snorkeled1442883snorkeled
snorted83813493sn_orted
snouted84311343sn_outed
snowed104613623sn_o_wed
snowshed1534423snowshed
snuffled15277033snuffled
snuggled11234953snuggled
soiled73822473s__oiled
soled65835173s__o_led
sooted73922593s_oo_ted
soothed113712743s_oothed
souled75419823s__ouled
spoiled104811353s_poiled
spoofed13399103spoo_fed
spooked144510473spoo_ked
spooler93711383spoo_ler
spooned103412443spoo_ned
spoored104411293spoo_red
stoled74521593s_to_led
stooged94310733stoo_ged
stooked124312303stoo_ked
stooped103813833stoo_ped
stoppled1345003stoppled
strolled937823strolled
swizzled2053013swizzled
swooned11368593swoo_ned
swooped13418753swoo_ped
swooshed15174273swooshed
tooled74918903_too_led
tootled83511043_tootled
touzled17367153_touzled
unboiled112410373unboiled
uncoiled112512683uncoiled
uncooled112710633uncooled
unfoiled12249723unfoiled
unoiled82415483un_oiled
unpolled1168943unpolled
unrolled9610413unrolled
unsoiled92412083unsoiled
wooled103715503_woo_led
woolled1136643_woolled

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.420425454.8
2DLD Change Limit1461621287.15620425.1
3Display Results1281280.0632031.7
 (SQL Overall)1786911287.63923391.9
 
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.