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 “beakt” 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
beak106534381beak_
beaks115326621beaks
beaky146118021beaky
beast76338641beast
beat66168301bea_t
beaut75135211beaut
baht96740012b_aht
bait66556002b_ait
bake105637512b_ake
bast66362412b_ast
bat510988952b_a_t
batt65053872b_att
beach124623892beach
bead75937922bea_d
beads85429502beads
beady114719922beady
beaked135919492beaked
beaker125520692beaker
beam86939232bea_m
beams95328172beams
beamy126218572beamy
bean66443862bea_n
beano75421552beano
beans75734692beans
bear66844642bea_r
beard86024962beard
bears75739042bears
beasts84519722beasts
beats76042242beats
beau66137272bea_u
beaus75127112beaus
beauts86015282beauts
beauty115410162beauty
beaux146513212beaux
beck126226572beck_
becket144619882becket
becks135522012becks
beet66457542be_et
befit105222662befit
begat86629722begat
beget85632552beget
begot84625952begot
belt65754032be_lt
bent67759912be_nt
berake124216082berake
beret74946362beret
berk105929842berk_
berks115423122berks
beset76739132beset
besot76429712besot
best66355322be_st
bet58376672be__t
betake124512702betake
bezant17814542bezant
bhakta1533652bhakta
bhakti1544322bhakti
blast76532572blast
blat66550952bla_t
bleak115915382bleak_
bleaks125112432bleaks
bleat75737002blea_t
boart78835932boart
boast75935702boast
boat66360312boa_t
bract96332722bract
brake116025342brake
braky145015812braky
brant74742172brant
brat66055542bra_t
break115319402break_
breaks124816422breaks
breast8319632breast
dealt65234282dealt
east46659102_east
eat36989052_ea_t
feast85932722feast
feat76458222fea_t
heart85440742heart
heat77061422hea_t
leak86233712leak_
leaks95923912leaks
leaky125217722leaky
leant56737782leant
leapt75027472leapt
least56134882least
meant76537202meant
meat66359602mea_t
neat46356782nea_t
peak106535202peak_
peaks114825622peaks
peaky145718152peaky
peart76440752peart
peat65967932pea_t
react74634332react
seat47575562sea_t
teak85930842teak_
teaks94222902teaks
teat45963632tea_t
weak117126302weak_
yeast85327942yeast

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.0802233637.5
2DLD Change Limit538001001.96627365.2
3Display Results1001000.0166250.0
 (SQL Overall)1786911002.06286659.1
 
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.