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 “snool” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
snool5511864(None) 
shool84523151shool
snood64616161snood
snook95115571snook
snools65715881snools
snoop75317171snoop
snoot55030141snoot
spool75219041spool
stool55619891stool
cool66940492_cool
drool65416102drool
enol45823822en_ol
enrol51014282enrol
fool75330592_fool
indol63714872indol
knoll9389602knoll
mool67533862_mool
noel45226552_noel
noil46133242_noil
nolo46229312_nolo
noo37154042_noo_
nook85728492_nook
noon47134622_noon
pool65835952_pool
salol55222142salol
santol64515242santol
school11410722school
scoop95617162scoop
scoot75729152scoot
scowl1012012972scowl
sheol84318372sheol
shnook1366342shnook
shoal83920272shoal
shoo75929892shoo_
shook124920162shook
shools94919012shools
shoon84022012shoon
shoos84226362shoos
shoot84235912shoot
shorl84720252shorl
skoal93811462skoal
sloop76118912sloop
snail57020202snail
snarl54921082snarl
snell54517302snell
snob65825592sn_ob
snobs74716152snobs
snog55623632sn_og
snogs66017492snogs
snoods74312452snoods
snooks104412832snooks
snooled84513942snooled
snoops84314172snoops
snoopy11449472snoopy
snoots64216682snoots
snooty94211512snooty
snooze15439992snooze
snoozle16305912snoozle
snoozy18517232snoozy
snore55424952snore
snort54833752snort
snot44745452sn_ot
snots55225122snots
snout54530632snout
snow76324792sn_ow
snows84719892snows
snowy115011562snowy
soil46138832s_oil
sokol94612292sokol
sol37256622s__ol
solo45538942s_olo
sook84933392s_ook
soon46240502s_oon
soot45761062s_oot
sotol54917652sotol
soul46435712s_oul
spoil75818652spoil
spoof105019012spoof
spook115416042spook
spools85115912spools
spoon74719442spoon
spoor75016352spoor
stood65517712stood
stook95218212stook
stools65117022stools
stoop75821542stoop
swoon85014782swoon
swoop105213432swoop
tool46735682_tool
uncool8610112uncool
wool76427372_wool

Search took 3 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 Filter178691538000.330541487.9
2DLD Change Limit53800911.67032215.6
3Display Results91910.0165687.5
 (SQL Overall)178691912.01688636.4
 
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.