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

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

207 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
debeaks143610(None) 
debeak1336761debeak_
beaks115326622__beaks
debags104211062deb_ags
debarks14388492debarks
debars94218042deb_ars
debeaked1634612debeaked
debeard1137352debeard
debeards1235502debeards
debunks1433762debunks
defeats113511232defeats
deleads9379702deleads
demeans1039722demeans
rebecks15288012rebecks
zebecks24274192zebecks
beads85429503__beads
beak106534383__beak_
beaky146118023__beaky
beams95328173__beams
beans75734693__beans
bears75739043__bears
beats76042253__beats
beaus75127113__beaus
becks135522013__becks
bedecks1635793bedecks
beheads1338523beheads
beleaps1138053beleaps
bemeans1148743bemeans
berks115423123__berks
bespeaks1643963bespeaks
bleaks125112433_bleaks
breaks124816433_breaks
cereals9313173cereals
creaks124315963_creaks
daks97130603d___aks
daybreaks1942173daybreaks
deadbeats1343683deadbeats
deads75726913d__eads
deals65435343d__eals
deans66131393d__eans
dears65736883d__ears
debag94212303deb_a_g
debar85517863deb_a_r
debark134210943deb_ark
debase94014473deb_ase
debases103814133debases
debate94419193deb_ate
debates103718533debates
debeaking1735923debeaking
debits94214503deb_its
debones103315113debones
debris93311493deb_ris
debs76530243deb___s
debtors1038533debtors
debts86418373deb__ts
debugs10467823deb_ugs
debunk1365113debunk_
debuts93911753deb_uts
debyes1238103deb_yes
decafs124010883de_cafs
decals93717713de_cals
decays124612913de_cays
decease1049523decease
deceases11410153deceases
deceits102810883deceits
decerns10119053decerns
decks124822193d__ecks
declass1038733declass
declaws1336253declaws
dedans85915073de_dans
deeds75423763de_e_ds
deejays1843433deejays
deems85421773de_e_ms
deeps84921773de_e_ps
deers64930523de_e_rs
dees56356633de_e__s
deets65330243de_e_ts
deewans11306903deewans
defats105114553de_fats
defeat103817163defea_t
defects134511523defects
defends12358773defends
defers105116943defe_rs
defleas1147223deflea_s
defoams1336193defoams
defrags1236193defrags
defrays1436113defrays
degas75119163de_ga_s
degerms1135623degerms
dejects17389223dejects
dekes105224453deke__s
delays104014053de_lays
delead84112343delea_d
deleave1147723deleave
deleaves1248063deleaves
deles65139253dele__s
deletes83117933deletes
deltas74414823delta_s
demarks14339233demarks
demean9510563demea_n
dements103016623dements
demes86032693deme__s
denars74621433de_nars
denes65639723dene__s
denials84114133denials
dentals83915393dentals
deodars937623deodars
depends11348993depends
deperms1236603deperms
derats74625063de_rats
derays105514253de_rays
dermas94116823derma_s
deserts82513053deserts
desexes1537833desexes
desks105913073d__esks
desmans1039003desmans
detects104011093detects
detents83615153detents
deters74724683dete_rs
detests83711743detests
deticks1437353deticks
devas96218883de_va_s
deveins1138813deveins
devels104313903deve_ls
devests114410473devests
dewans105215143de_wans
dewars105117073de_wars
dewlaps1334663dewlaps
dexes135224513dexe__s
dhaks13479703d__haks
dibbuks1643163dibbuks
diebacks1745963diebacks
djebels1753293djebe_ls
doblas93812293dobla_s
dobras94811913dobra_s
dogears937513dogears
dreads84115023d_reads
dreams94513983d_reams
drears74614253d_rears
drecks13459203d_recks
dreks105714753d_re_ks
dybbuks1941603dybbuks
ebooks12358333_ebooks
eyebeams1542133eyebeams
freaks134713063_freaks
geeks104915843ge_e_ks
hebes105521673hebe__s
jebels15418913jebe_ls
jetbeads1842483jetbeads
kebabs14418513keb_abs
kebars124112493keb_ars
keblahs1634563keblahs
keeks84717253ke_e_ks
leaks95923913__leaks
lebens8310093lebe_ns
leeks95318893le_e_ks
obeahs1135863_obeahs
peaks114825623__peaks
peeks115021113pe_e_ks
phreaks1634543phreaks
rebars84019833reb_ars
rebeck14419913rebeck_
rebecs103913673rebe_cs
rebels84518133rebe_ls
rebooks134010513rebooks
redears82814453redears
reeks94124033re_e_ks
regears83012463regears
rehears103312773rehears
reheats104513533reheats
repeals94014533repeals
repeats94316063repeats
reperks13298093reperks
rereads81512293rereads
reseals73917683reseals
reseats74319593reseats
reseaus74012153reseaus
reseeks11348623reseeks
resoaks1148973resoaks
respeaks1434953respeaks
reteams9339563reteams
retears72814923retears
reveals103812743reveals
rewears102911043rewears
screaks13469363screaks
seeks94724643se_e_ks
shebeans1344703shebeans
sneaks104312493_sneaks
speaks125114583_speaks
squeaks2034523squeaks
steaks104415853_steaks
streaks114411273streaks
teaks94222903__teaks
tiebreaks1562483tiebreaks
tweaks1335963_tweaks
unbears998043unbears
upbears1195423upbears
upbeats1195743upbeats
webcams1643073webcams
webers11310943webe_rs
weeks125017863we_e_ks
wreaks134711113_wreaks
xebecs17355363xebe_cs
zebeck23255203zebeck_
zebecs19316183zebe_cs
zebras1737853zebra_s
zebrass1834113zebrass

Search took 8 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 Filter1786911340270.423422437.4
2DLD Change Limit1340272077.01619103.1
3Display Results2072070.0762723.7
 (SQL Overall)1786912077.51523777.9
 
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.