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

320 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
raid5524308(None) 
aid49269091_aid
arid57642721arid
braid85822261braid
caid77837541caid
laid56439151laid
maid75537671maid
paid75737491paid
qaid146023851qaid
rabid84520781rabid
rad47662011ra_d
rai37658221rai_
raia46638381raia
raids65827521raids
rail46147761rail
rain46251731rain
rais45252621rais
rand55839571rand
ranid66429331ranid
rapid86422031rapid
rid46754641r_id
said55742121said
acid77533402acid
ad311975042_a_d
add510132372_add
afraid1049722afraid
ai211288402_ai_
aide56045012_aide
aids57846372_aids
ail37171052_ail
aim57858222_aim
ain37579102_ain
air38058402_air
ais39083582_ais
ait38093912_ait
amid77036362amid
and47244182_and
aramid93315612aramid
aria46245422aria
aril45843022aril
aroid65428342aroid
avid88325972avid
bad67763162ba_d
bail65042802bail
bait66556002bait
bald76432902bald
band76740922band
bard75648862bard
baud74928422baud
bawd105520842bawd
bid67751822_bid
brad75234342bra_d
braids95015692braids
brail75525552brail
brain76229382brain
brand85124492brand
cad67456372ca_d
cadi75732192cadi
caids85226432caids
cain65643912cain
caird85717232caird
canid85526342canid
card710245872card
chid106626412chid
dad58456172da_d
dais57040702dais
did56850532_did
drail65020972drail
drain65222892drain
droid74218542droid
druid74111322druid
fad77452422fa_d
fail74840242fail
fain75840562fain
fair76332522fair
fard85639062fard
fid76847702_fid
frail85220212frail
fraud939862fraud
gad57556662ga_d
gadi66329732gadi
gadid85517382gadid
gaed66031512gaed
gain56042162gain
gait56150192gait
gaud67025432gaud
gid57047282_gid
grad66829862gra_d
grail64622872grail
grain65126252grain
grand75122692grand
gravid113710982gravid
grid65829622grid
guid66022832guid
had77658772ha_d
haed86338582haed
haik115526982haik
hail74839062hail
hair76330142hair
halid94424982halid
hand86833712hand
hard85443502hard
hid76248392_hid
id38941852__id
imid76122302imid
irid55927182irid
jail115529092jail
kadi96224842kadi
kaif116933942kaif
kail85131502kail
kain85334302kain
kid86540632_kid
krait94726772krait
lad48165712la_d
laic65931562laic
lain46146282lain
lair45934152lair
laird65417792laird
land56337312land
lard56742002lard
laud56527722laud
lid47453532_lid
loid55531502loid
mad68958722ma_d
maids86327152maids
mail65543452mail
maim85831492maim
main65345522main
mair66133782mair
maud75325402maud
mid67354482_mid
naiad6313402naiad
naif76839022naif
nail45838652nail
nard56634452nard
orad56031692ora_d
oxid12815492oxid
pad68057332pa_d
padi76331792padi
paik105726802paik
pail66141832pail
pain65647242pain
pair66031512pair
pard76441322pard
pavid115717002pavid
plaid85118302plaid
qadi145621112qadi
qaids156116322qaids
quid144922362quid
rabic93817402rabic
race66746262race
raced87635312raced
rack106234882rack
racy95825682racy
radii64016412radii
radio64922492radio
radix134414602radix
rads56046612rads
raff104933042raff
raft76245912raft
rag45761322ra_g
raga55930812raga
rage55742352rage
raged74829452raged
ragg65622692ragg
ragi56032282ragi
ragis66325602ragis
rags55448372rags
rah68052402ra_h
raias54631122raias
raided85017702raided
raider74318742raider
railed74727542railed
rails55937402rails
rained75024602rained
rains55140232rains
rainy85921082rainy
raise54828052raise
raised76120332raised
raita54623072raita
raj105740222ra_j
raja117918682raja
rake84841572rake
raked105831422raked
raki87127832raki
rakis95323442rakis
raku85423772raku
rale45050562rale
ram56867272ra_m
rami66034092rami
ramie75027822ramie
ramp85934002ramp
rams65950772rams
ran38266622ra_n
rancid9513862rancid
rands65930452rands
randy95022082randy
rang56939172rang
rani46640112rani
ranids75118702ranids
ranis55235842ranis
rank85135532rank
rant45864682rant
rap56261962ra_p
rape65041632rape
raped85334622raped
rapids94913892rapids
raps66247732raps
rapt67245312rapt
rare45348432rare
rared65738322rared
ras37575392ra_s
rase46149982rase
rased65033932rased
rash76039932rash
rasp66029162rasp
rat37892742ra_t
rate45458762rate
rated65441382rated
rath76037662rath
ratio55227582ratio
rato45436972rato
rats46260372rats
rave75542092rave
raved94931432raved
ravin85624652ravin
raw67252252ra_w
rawin85521472rawin
raws75238212raws
rax108445722ra_x
raxed135622662raxed
ray66361992ra_y
raya75224822raya
rayed95127502rayed
rays77642352rays
raze135235432raze
razed155027982razed
razz125219422razz
read55942532read
readd74617132readd
rebid85121362rebid
red46755812r_ed
redd66323182redd
redid74922392redid
reed55549622reed
rei35647252rei_
reif76937652reif
rein46040892rein
reis45343232reis
relaid75518442relaid
rend56136572rend
repaid94716322repaid
resaid74517082resaid
resid64124092resid
ria36745512r_ia
rial45938102rial
rias45540602rias
rib56848042r_ib
ride55945142r_ide
rids56539562r_ids
rif65951572r_if
rig46748132r_ig
rigid7913892rigid
rim56052282r_im
rin36663192r_in
rind56535612rind
rip56851312r_ip
road56332112road
rod47953902r_od
roil46235292roil
rood56733002rood
rudd65917482rudd
rued55729792rued
ruin47430512ruin
rynd86414102rynd
sad47459212sa_d
sadi55834652sadi
saids65328862saids
sail45447162sail
sain45551292sain
sand55338472sand
sapid84720932sapid
sard55344242sard
sayid95516722sayid
skid95720942skid
slid55828992slid
staid66722082staid
tabid84418262tabid
tad47959832ta_d
tail45443652tail
tain45548072tain
trad55630912tra_d
traik95418202traik
trail55126772trail
train56529112train
trait56940842trait
triad65217722triad
ursid6311482ursid
vail75432552vail
vain75233002vain
vair75624142vair
valid94618392valid
vapid115614282vapid
vid77241822_vid
void86220572void
wad77053902wa_d
wadi86228182wadi
waif105836752waif
wail75238822wail
wain75840202wain
wair75830052wair
wait75553692wait
wand85833882wand
ward86542252ward
whid115418882whid
yaird96111912yaird
yald86920612yald
yard85633252yard
yaud87020082yaud
yid76640842_yid

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 Filter178691298720.296603685.8
2DLD Change Limit298723200.92032469.6
3Display Results3203200.0804000.0
 (SQL Overall)1786913201.296137878.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.