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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

122 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
shook12492016(None) 
chook146015041chook
hook116133281_hook
shnook1366341shnook
shock144917031shock
shoo75929891shoo_
shooks134515631shooks
shool84523151shool
shoon84022011shoon
shoos84226361shoos
shoot84235911shoot
snook95115571snook
sook84933391s_ook
spook115416041spook
stook95218211stook
bhoot104322102bhoot
book106836332_book
brook114717762brook
chock164316612chock
chooks155312792chooks
cook107236932_cook
crook115217572crook
ebook114510802ebook
gook96429602_gook
hock136031302_hock
holk116027942_holk
honk116931192_honk
hood85132332_hood
hoof106036582_hoof
hooka125513902_hooka
hooks125027122_hooks
hooky155220262_hooky
hoop96129982_hoop
hoot75752102_hoot
howk145221962_howk
kook75822602_kook
look87333472_look
nook85728492_nook
rook85532032_rook
schnook1654482schnook
school11410722school
scoop95617162scoop
scoot75729152scoot
shack145321752shack
shako125516092shako
shank125422192shank
shark126225022shark
sheik122514662sheik
sheol84318372sheol
shirk124817842shirk
shlock15378192shlock
shmo95318102shmo_
shnooks1485582shnooks
shoal83920272shoal
shoat85633952shoat
shocks154414582shocks
shod86225062sh_od
shoe75933442sh_oe
shoed95723012shoed
shoer84722162shoer
shoes85429662shoes
shog86025142sh_og
shogi95014012shogi
shogs95319712shogs
shoji15419962shoji
sholom11910112sholom
shone83725982shone
shooed103916082shooed
shools94919012shools
shoots94619362shoots
shop95629842sh_op
shops104222902shops
shore85432652shore
shorl84720252shorl
shorn85722182shorn
short85040532short
shot76150262sh_ot
shote85526102shote
shots84730852shots
shott85332192shott
shout85433172shout
shove114421042shove
show106229192sh_ow
shown115216482shown
shows115324582shows
showy145714012showy
shoyu1138912shoyu
shtik123210962shtik
shuck144314532shuck
skyhook1642582skyhook
sloop76118912sloop
smock135311672smock
snood64616162snood
snooks104412832snooks
snool55118642snool
snoop75317172snoop
snoot55030142snoot
soak87227662s_oak
sock105233212s_ock
sooks94425452s_ooks
soon46240502s_oon
soot45761062s_oot
souk86127172s_ouk
spoof105019012spoof
spooks124312932spooks
spooky15418092spooky
spool75219042spool
spoon74719442spoon
spoor75016352spoor
stock114417562stock
stood65517712stood
stooks105115372stooks
stool55619892stool
stoop75821542stoop
stork96819692stork
strook10410302strook
swoon85014782swoon
swoop105213432swoop
took86531072_took
unhook1347522unhook
whoof144612692whoof
whoop134211442whoop

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.310576422.6
2DLD Change Limit538001221.75030742.9
3Display Results1221220.0333697.0
 (SQL Overall)1786911222.09385375.5
 
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.