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

132 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
bleat7573700(None) 
beat66168301b_eat
blat66550951bl_at
bleak115915381bleak
blear75918681blear
bleats85518611bleats
blent76230951blent
blest76431721blest
blet66247671ble_t
bloat75229921bloat
cleat76335061cleat
pleat74734471pleat
ablest84721832ablest
alert54740652alert
bat510988952b__at
bead75937922b_ead
beak106534382b_eak
beam86939232b_eam
bean66443862b_ean
bear66844642b_ear
beast76338642b_east
beats76042242b_eats
beau66137272b_eau
beaut75135212b_eaut
beet66457542b_eet
begat86629722begat
belay105021522belay
beleap10410282beleap
beleapt11310252beleapt
belt65754032b_elt
bent67759912b_ent
best66355322b_est
bet58376672b_e_t
beta66234132b_eta
blab86629132bl_ab
blae66134642bl_ae
blah98625062bl_ah
blam86131702bl_am
blast76532572blast
blate75933782bl_ate
blats75132502bl_ats
blaw97026722bl_aw
bleach133611402bleach
bleaks125112432bleaks
blears85116452blears
bleary115112552bleary
bleated104015972bleated
bleater94515302bleater
bleb85425222ble_b
blebs96416152blebs
bled75729312ble_d
bleed85019802bleed
bleep95013452bleep
blend85317452blend
bless75917812bless
blets75324942blets
blew94722432ble_w
bloats85215762bloats
blot65842322bl_ot
bluest84016482bluest
bluet75631192bluet
blunt75525022blunt
blurt77625622blurt
boat66360312b_oat
brat66055542b_rat
bread85523112bread
break115319402break
bream95121812bream
breast8319632breast
breath113916262breath
brent75734132brent
cheat105732452cheat
clean75420412clean
clear76219052clear
cleats84919312cleats
cleft106222852cleft
clept95725772clept
eat36989052__eat
elect74327032elect
feat76458222_feat
flat77147822fl_at
flea75628492flea_
fleam106017282fleam
fleas86423662fleas
fleet85932332fleet
float85928572float
gleam86916732gleam
glean65818202glean
gleet65532342gleet
gloat65427682gloat
great66034242great
heat77061422_heat
ilea45931462ilea_
ileac75814172ileac
ileal56118082ileal
lat37593402_l_at
lea37660182_lea_
lead56038852_lead
leaf76441032_leaf
leak86233712_leak
leal46043272_leal
lean46345242_lean
leant56737782_leant
leap66032682_leap
leapt75027472_leapt
lear47045952_lear
leas45954182_leas
least56134882_least
leet45957902_leet
left76340482_left
lent46360532_lent
lept66440882_lept
lest46956322_lest
let36481472_le_t
meat66359602_meat
neat46356782_neat
olea46532722olea_
oleate6318882oleate
peat65967932_peat
plat66048872pl_at
plea66830602plea_
plead85818462plead
pleas75627032pleas
pleats85218592pleats
seat47575562_seat
slat46959022sl_at
sleet55639132sleet
slept75728102slept
sweat85628402sweat
teat45963632_teat
treat56240352treat
wheat114924572wheat

Search took 5 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.186960704.3
2DLD Change Limit538001323.76614285.7
3Display Results1321320.0801650.0
 (SQL Overall)1786911324.03244318.2
 
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.