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

250 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
bided9542496(None) 
abided105313311abided
aided75828931aided
bide76041501bide_
bider85728371bider
bides85536771bides
bidet84935621bidet
biked125320031biked
biped104718831biped
birded104414301birded
boded95124961boded
hided105222441hided
nided75920871nided
sided74825951sided
tided76322511tided
abide86223712abide_
abider95314462abider
abides94719892abides
aboded104912512aboded
added84918432added
aide56045002aide_
aider65431132aider
aides65336602aides
ailed66240282ailed
aimed85626052aimed
aired66032922aired
baaed85218162baaed
bade75140882bade_
badged114814792badged
bailed94726652bailed
baited95319242baited
baked126130772baked
balded105417512balded
baled85436442baled
banded105223172banded
baned85436352baned
barded105426422barded
bared85144482bared
based85331582based
bated85935532bated
bayed115423022bayed
beaded104922422beaded
bed67950622b__ed
bedded115114072bedded
bedel84219402bedel
bedew114513042bedew
bended105521232bended
betided114810202betided
biased94012222biased
bibbed104712342bibbed
bice86235562bice_
bicep115413542bicep
bices95029962bices
bid67751812bi__d
bidden104010792bidden
bidder104114862bidder
biddy124612692biddy
biders94822802biders
bidets95215532bidets
bidi78226592bid_i
bidis86721142bidis
bids75838452bid_s
bield84614652bield
bielded11226712bielded
bier65531832bi_er
biffed15449882biffed
bifid11910702bifid
bike106532602bike_
biker116022562biker
bikes117529472bikes
bile66147182bile_
biles75542142biles
bilged105513182bilged
bilked134012942bilked
billed94224902billed
bind76234512bi_nd
binder94422872binder
bine66650862bine_
biner75930692biner
bines76946792bines
binged105920822binged
binned94414542binned
bipeds11458052bipeds
bipod104410822bipod
bird76128322bi_rd
birder94915492birder
birdied11329432birdied
birled94416992birled
birred94713202birred
bise66437102bise_
bises75435622bises
bite66547002bite_
biter75030032biter
bites75641172bites
bitted94418482bitted
bize155926292bize_
bizes165923662bizes
bladed104717762bladed
bled75729312b_led
bleed85019802bleed
blinded114810022blinded
blued84520322blued
bode75838752bode_
bodes84935102bodes
bodied103814582bodied
boiled95020952boiled
bonded104719952bonded
boned85133242boned
booed85127272booed
bored85034302bored
bowed114533422bowed
boxed154318612boxed
braided114013212braided
bred75130972b_red
breed85526692breed
bribed115312842bribed
bride86425532bride_
brides94423512brides
bridged12339032bridged
bridled113611142bridled
brinded115112052brinded
brined95118412brined
budded113912332budded
budged114517242budged
builded1136472builded
bused85624492bused
ceded96118562ceded
chided135113962chided
cider84723312cider
cited84421952cited
coded95433182coded
diced95824682diced
died66137852di_ed
diked115024682diked
dined76431992dined
dived106321372dived
duded84417132duded
eide55832242eide_
eider64624742eider
elided84814672elided
ended74421262ended
faded105025242faded
fidged124610932fidged
fifed125115972fifed
filed95331902filed
fined94930502fined
fired94829742fired
fixed165416952fixed
gibed96215962gibed
gied64631982gi_ed
gilded94413222gilded
girded93712492girded
glided94513902glided
grided95117042grided
guided94014112guided
haded105227622haded
hide85134642hide_
hider95024082hider
hides95129422hides
hied85434042hi_ed
hiked135919202hiked
hired95226262hired
hived125217912hived
ibidem1134792ibidem
iced78721892_iced
idea59122772_idea
idem76121062_idem
ides57734232_ides
idled74915212_idled
ired55131872_ired
jaded144417032jaded
jibed155114162jibed
jived165115042jived
kidded13299392kidded
kited105120092kited
laded74232612laded
lidded93410242lidded
lied55838092li_ed
liked104523812liked
limed85426802limed
lined64934642lined
lived95523722lived
loided83414022loided
miked125020452miked
milded104416152milded
mimed105622732mimed
minded103817832minded
mined85333352mined
mired85729222mired
mixed155717252mixed
nide55535792nide_
nides65229132nides
nixed135714222nixed
oiled64429472oiled
pied75035362pi_ed
piked125623312piked
piled85232992piled
pined85935322pined
piped105123162piped
prided103618032prided
raided85017702raided
reded74829122reded
riced85825542riced
ridded93615122ridded
ride55945132ride_
rider65231302rider
rides66140812rides
ridged94014222ridged
riled65833252riled
rimed84826372rimed
rinded84418982rinded
riped85226432riped
rived94825612rived
side55444492side_
sides65838362sides
sidled84215172sidled
siped84927682siped
sired66134282sired
sited65130742sited
sized155519242sized
tide55237382tide_
tides64830152tides
tidied83613272tidied
tied55535212ti_ed
tiled64832942tiled
timed85223612timed
tined65434532tined
tired65228902tired
viced115118182viced
vide85432762vide_
video96014952video
vied86328632vi_ed
vined95626152vined
vised95518762vised
voided114011132voided
waded106024752waded
wide85235412wide_
widen94717972widen
wider94826352wider
wides94832822wides
wifed125117742wifed
wilded113714502wilded
wiled95231552wiled
winded114918212winded
wined94434182wined
wiped114722082wiped
wired95327642wired
wised95123342wised
wited94727142wited
wived125121502wived

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.296603685.8
2DLD Change Limit538002501.67332157.8
3Display Results2502500.0633968.3
 (SQL Overall)1786912502.03287938.5
 
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.