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
raid5524307(None) 
aid49269071_aid
arid57642711arid
braid85822261braid
caid77837531caid
laid56439141laid
maid75537631maid
paid75737481paid
qaid146023841qaid
rabid84520771rabid
rad47662001ra_d
rai37658221rai_
raia46638381raia
raids65827511raids
rail46147761rail
rain46251731rain
rais45252621rais
rand55839561rand
ranid66429331ranid
rapid86422031rapid
rid46754621r_id
said55742111said
acid77533392acid
ad311975032_a_d
add510132362_add
afraid1049712afraid
ai211288392_ai_
aide56044992_aide
aids57846352_aids
ail37171042_ail
aim57858212_aim
ain37579092_ain
air38058392_air
ais39083572_ais
ait38093902_ait
amid77036332amid
and47244162_and
aramid93315602aramid
aria46245422aria
aril45843022aril
aroid65428332aroid
avid88325962avid
bad67763152ba_d
bail65042802bail
bait66556002bait
bald76432902bald
band76740902band
bard75648862bard
baud74928422baud
bawd105520842bawd
bid67751782_bid
brad75234342bra_d
braids95015682braids
brail75525552brail
brain76229382brain
brand85124492brand
cad67456362ca_d
cadi75732172cadi
caids85226422caids
cain65643912cain
caird85717232caird
canid85526342canid
card710245872card
chid106626402chid
dad58456162da_d
dais57040702dais
did56850512_did
drail65020972drail
drain65222892drain
droid74218532droid
druid74111322druid
fad77452412fa_d
fail74840242fail
fain75840562fain
fair76332522fair
fard85639062fard
fid76847682_fid
frail85220212frail
fraud939862fraud
gad57556652ga_d
gadi66329722gadi
gadid85517372gadid
gaed66031512gaed
gain56042162gain
gait56150192gait
gaud67025432gaud
gid57047262_gid
grad66829862gra_d
grail64622872grail
grain65126252grain
grand75122692grand
gravid113710972gravid
grid65829612grid
guid66022822guid
had77658762ha_d
haed86338582haed
haik115526982haik
hail74839062hail
hair76330142hair
halid94424972halid
hand86833702hand
hard85443502hard
hid76248362_hid
id38941832__id
imid76122272imid
irid55927162irid
jail115529092jail
kadi96224822kadi
kaif116933922kaif
kail85131492kail
kain85334292kain
kid86540612_kid
krait94726772krait
lad48165702la_d
laic65931562laic
lain46146282lain
lair45934152lair
laird65417792laird
land56337302land
lard56742002lard
laud56527722laud
lid47453512_lid
loid55531482loid
mad68958702ma_d
maids86327132maids
mail65543432mail
maim85831472maim
main65345502main
mair66133762mair
maud75325392maud
mid67354452_mid
naiad6313402naiad
naif76839012naif
nail45838652nail
nard56634452nard
orad56031692ora_d
oxid12815482oxid
pad68057322pa_d
padi76331782padi
paik105726802paik
pail66141832pail
pain65647242pain
pair66031512pair
pard76441322pard
pavid115717002pavid
plaid85118302plaid
qadi145621102qadi
qaids156116312qaids
quid144922352quid
rabic93817392rabic
race66746262race
raced87635312raced
rack106234882rack
racy95825682racy
radii64016412radii
radio64922492radio
radix134414592radix
rads56046602rads
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
ran38266612ra_n
rancid9513862rancid
rands65930452rands
randy95022082randy
rang56939152rang
rani46640102rani
ranids75118702ranids
ranis55235832ranis
rank85135522rank
rant45864672rant
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
rebid85121352rebid
red46755802r_ed
redd66323172redd
redid74922392redid
reed55549622reed
rei35647252rei_
reif76937642reif
rein46040892rein
reis45343232reis
relaid75518442relaid
rend56136572rend
repaid94716322repaid
resaid74517082resaid
resid64124092resid
ria36745502r_ia
rial45938092rial
rias45540592rias
rib56848022r_ib
ride55945122r_ide
rids56539542r_ids
rif65951552r_if
rig46748122r_ig
rigid7913892rigid
rim56052272r_im
rin36663182r_in
rind56535602rind
rip56851302r_ip
road56332112road
rod47953892r_od
roil46235292roil
rood56733002rood
rudd65917472rudd
rued55729792rued
ruin47430512ruin
rynd86414102rynd
sad47459202sa_d
sadi55834642sadi
saids65328852saids
sail45447162sail
sain45551292sain
sand55338462sand
sapid84720932sapid
sard55344242sard
sayid95516722sayid
skid95720912skid
slid55828982slid
staid66722072staid
tabid84418252tabid
tad47959822ta_d
tail45443652tail
tain45548072tain
trad55630912tra_d
traik95418202traik
trail55126772trail
train56529112train
trait56940842trait
triad65217722triad
ursid6311482ursid
vail75432552vail
vain75233002vain
vair75624142vair
valid94618382valid
vapid115614282vapid
vid77241802_vid
void86220562void
wad77053892wa_d
wadi86228172wadi
waif105836742waif
wail75238822wail
wain75840192wain
wair75830052wair
wait75553692wait
wand85833872wand
ward86542252ward
whid115418872whid
yaird96111912yaird
yald86920602yald
yard85633252yard
yaud87020082yaud
yid76640822_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.0762351197.4
2DLD Change Limit298723201.06328101.6
3Display Results3203200.0764210.5
 (SQL Overall)1786913201.215147070.8
 
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.