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

100 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
brook11471776(None) 
book106836331b_ook
brock136017071brock
broo65129821broo_
brood84620241brood
brooks125813881brooks
broom95022211broom
broos75126411broos
crook115217571crook
rook85532031_rook
betook12439602betook
bhoot104322102bhoot
block134917842block
blood85319522blood
bloom95918972bloom
bloop96116152bloop
bock126032512b_ock
bonk105531712b_onk
boo58163662b_oo_
boob85932582b_oob
books115729712b_ooks
boom87435672b_oom
boon67142172b_oon
boor66130682b_oor
boos67955032b_oos
boot67759372b_oot
bork106933822b_ork
boron76727142boron
bosk105825732b_osk
brank115222282brank
break115319402break
brick134618152brick
brink116122002brink
brio65432492brio_
brios74725732brios
brisk115615982brisk
bro56236602br_o_
broad84817692broad
brocks145214152brocks
broil74918222broil
broke116019782broke
brome94421972brome
bromo95217202bromo
bromos104213312bromos
bronc91714342bronc
brooch13368442brooch
broods95416382broods
broody124510082broody
brooked143610032brooked
brookie1347372brookie
brooms104915872brooms
broomy13449952broomy
bros65635662br_os
brose75227032brose
brosy106115382brosy
broth106521092broth
brow97228442br_ow
brown105619532brown
brows105425982brows
brusk114912432brusk
chook146015042chook
cook107236932_cook
croak115216632croak
crock135921992crock
crooks124914412crooks
croon75522782croon
drool65416102drool
droop85814822droop
drouk1039432drouk
ebook114510802ebook
frock145314652frock
gook96429602_gook
grok95819682gr_ok
groom85317982groom
hook116133282_hook
iroko939662iroko
kook75822612_kook
kroon94514482kroon
look87333472_look
nook85728492_nook
proof105221532proof
rock105735182_rock
rood56733002_rood
roof75738832_roof
rooks95325042_rooks
rooky126117622_rooky
room66235082_room
root45655922_root
shook124920162shook
snook95115572snook
sook84933392_sook
spook115416042spook
stook95218212stook
strook10410302strook
took86531072_took
troak95213572troak
trock114817602trock
troop76417532troop
trooz145016152trooz
vroom105312472vroom

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.343520965.0
2DLD Change Limit538001002.04626295.2
3Display Results1001000.0303333.3
 (SQL Overall)1786911002.41973869.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.