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

219 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
biped10471883(None) 
bided95424961bided
biked125320031biked
bipeds11458051bipeds
bipod104410821bipod
piped105123161piped
riped85226431riped
siped84927681siped
wiped114722081wiped
abided105313312abided
aided75828932aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
aliped95414282aliped
amped104820512amped
aped78538152_aped
baaed85218162baaed
bailed94726652bailed
baited95319242baited
baked126130772baked
baled85436442baled
baned85436352baned
bared85144482bared
based85331582based
bated85935532bated
bayed115423022bayed
bed67950622b__ed
beeped115313452beeped
biased94012222biased
bibbed104712342bibbed
bice86235562bice_
bicep115413542bicep
bices95029962bices
bid67751792bi__d
bide76041482bide_
bider85728372bider
bides85536772bides
bidet84935622bidet
bield84614652bield
bier65531832bi_er
biffed15449882biffed
bifid11910702bifid
bike106532602bike_
biker116022562biker
bikes117529472bikes
bile66147182bile_
biles75542142biles
bilged105513182bilged
bilked134012942bilked
billed94224902billed
bind76234512bi_nd
bine66650862bine_
biner75930692biner
bines76946792bines
binged105920822binged
binned94414542binned
bipedal1245682bipedal
bipods11408592bipods
bird76128322bi_rd
birded104414302birded
birled94416992birled
birred94713202birred
bise66437102bise_
bises75435622bises
bite66547002bite_
biter75030032biter
bites75641172bites
bitted94418482bitted
bize155926292bize_
bizes165923662bizes
bled75729312b_led
bleed85019802bleed
blipped14377192blipped
blued84520322blued
boded95124962boded
boiled95020952boiled
boned85133242boned
booed85127272booed
bopped134413402bopped
bored85034302bored
bowed114533422bowed
boxed154318612boxed
bred75130972b_red
breed85526692breed
bribed115312842bribed
brined95118412brined
bumped134414002bumped
burped116215502burped
bused85624492bused
caped104931802caped
cited84421952cited
coped105036842coped
diced95824682diced
died66137852di_ed
diked115024682diked
dined76431992dined
dipped123517492dipped
dived106321372dived
doped95326712doped
duped95118322duped
fifed125115972fifed
filed95331902filed
fined94930502fined
fired94829742fired
fixed165416952fixed
gaped96123532gaped
gibed96215962gibed
gied64631982gi_ed
gimped123911472gimped
gipped124815902gipped
griped104114712griped
hided105222442hided
hied85434042hi_ed
hiked135919202hiked
hipped144317692hipped
hired95226262hired
hived125217912hived
hoped115628182hoped
hyped145313332hyped
iced78721892_iced
imped105117982imped
ired55131872_ired
japed156217632japed
jibed155114162jibed
jived165115042jived
kipped153114572kipped
kited105120092kited
lied55838092li_ed
liked104523812liked
limed85426802limed
limped114817122limped
lined64934642lined
lipe66839732lipe_
lipid85916172lipid
lipped114419542lipped
lisped94113422lisped
lived95523722lived
loped85128332loped
miked125020452miked
mimed105622732mimed
mined85333352mined
mired85729222mired
mixed155717252mixed
moped105424732moped
nided75920872nided
nipped113615852nipped
nixed135714222nixed
oiled64429472oiled
oped76230152_oped
ped66751522__ped
pied75035362pi_ed
piked125623312piked
piled85232992piled
pimped134913482pimped
pined85935322pined
pipe86434432pipe_
piper96523192piper
pipes96030142pipes
pipet95533322pipet
pipped104516542pipped
raped85334622raped
riced85825542riced
riled65833252riled
rimed84826372rimed
ripe66038922ripe_
ripen75619262ripen
riper74328402riper
ripes75435772ripes
ripped114419012ripped
rived94825612rived
roped84630802roped
sided74825952sided
sipe67341042sipe_
sipes76036952sipes
sipped113720632sipped
sired66134282sired
sited65130742sited
sized155519242sized
sliped95417062sliped
sniped94913482sniped
sped76031492_sped
spied85427712spied
stiped94517072stiped
swiped123811092swiped
taped85327422taped
tided76322512tided
tied55535212ti_ed
tiled64832942tiled
timed85223612timed
tined65434532tined
tipped114418262tipped
tired65228902tired
toped85631312toped
typed115815452typed
umped104717272umped
upped103715162upped
urped84615282urped
viced115118182viced
vied86328632vi_ed
vined95626152vined
viper105017302viper
vised95518762vised
wifed125117742wifed
wiled95231552wiled
wimped144211512wimped
wined94434182wined
wipe94830282wipe_
wiper105421292wiper
wipes104827082wipes
wired95327642wired
wised95123342wised
wisped123411892wisped
wited94727142wited
wived125121502wived
yipe96722182yipe_
yipes106017842yipes
yipped143613282yipped
zipped203612982zipped

Search took 2 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.300595636.7
2DLD Change Limit538002191.56034487.2
3Display Results2192190.0633476.2
 (SQL Overall)1786912191.92392923.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.