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

107 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
breaks12481642(None) 
beaks115326621b_eaks
bleaks125112431bleaks
breads95419201breads
break115319401break_
breams104815041breams
breeks125310791breeks
creaks124315961creaks
freaks134713061freaks
wreaks134711111wreaks
araks94820882ar_aks
areas55935772area_s
beads85429502b_eads
beak106534382b_eak_
beaky146118022b_eaky
beams95328172b_eams
beans75734692b_eans
bears75739042b_ears
beats76042242b_eats
beaus75127112b_eaus
becks135522012b_ecks
berake124216082berake
berakes134815772berakes
berks115423122b_erks
bleak115915382bleak_
blears85116452blears
bleats85518612bleats
boreas85421732borea_s
brads85528292br_ads
braes75735052br_aes
brags85625102br_ags
brake116025342br_ake
brakes124923122br_akes
braky145015812br_aky
branks124817382branks
brans75437432br_ans
bras65746452br_a_s
brass75428022br_ass
brats75336012br_ats
braws106425192br_aws
brays106723112br_ays
breach134213722breach
bread85523112brea_d
bready124511182bready
breaker133912922breaker
breakers143810972breakers
breakup1543462breakup
breakups1642512breakups
bream95121812brea_m
breast8319632breast
breasts939702breasts
breath113916262breath
breaths124411182breaths
bredes94818472bredes
breeds94914882breeds
brees75632552bre_es
brens75823362bre_ns
brents84717272brents
breves115516422breves
brewis11469982brewis
brews105617072bre_ws
briars84814822briars
bricks144614622bricks
brinks124616312brinks
brisks124611402brisks
broads94515142broads
brocks145214152brocks
brooks125813882brooks
bureaus979282bureaus
creak115418432creak_
creaky154911552creaky
creams104715252creams
creeks124812922creeks
croaks125812982croaks
dreads84115022dreads
dreams94513982dreams
drears74614252drears
drecks13459202drecks
dreks105714742dre_ks
freak125115242freak_
freaky16439232freaky
greats76318392greats
leaks95923912_leaks
oreads73915772oreads
peaks114825622_peaks
phreaks1634542phreaks
reads64835272_reads
reals55038652_reals
reams75729622_reams
reaps75626192_reaps
rears54739652_rears
recks115625132_recks
reeks94124032_reeks
screaks13469352screaks
sneaks104312492sneaks
speaks125114582speaks
steaks104415852steaks
streaks114411272streaks
teaks94222902_teaks
treads74817912treads
treats64821692treats
treks96016852tre_ks
troaks104410592troaks
tweaks1335962tweaks
ureas55826012urea_s
wreak125513272wreak_
wrecks15418882wrecks

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 Filter178691825510.1101624463.6
2DLD Change Limit825511072.45333653.1
3Display Results1071070.0303566.7
 (SQL Overall)1786911072.59368912.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.