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

264 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
raids6582752(None) 
aids57846371_aids
braids95015691braids
caids85226431caids
maids86327151maids
qaids156116321qaids
rads56046611ra_ds
raias54631121raias
raid55243081raid_
rails55937401rails
rains55140231rains
rais45252621rai_s
rands65930451rands
ranids75118701ranids
rapids94913891rapids
rids56539561r_ids
saids65328861saids
acids87121012acids
adds67622462_adds
ads49755742_a_ds
aid49269092_aid_
aide56045012_aide
aides65336612_aides
ails45654722_ails
aims67738192_aims
ains46158892_ains
airs46447432_airs
ais39083582_ai_s
aits46355542_aits
amids85627522amids
ands57833622_ands
aramids102810512aramids
arias55438032arias
arid57642722arid_
arils58732202arils
aroids75118222aroids
bads77048872ba_ds
bails75933522bails
baits76630582baits
balds85524642balds
bands85233432bands
bards87139642bards
bauds85821042bauds
bawds116115492bawds
bids75838462_bids
brads85528292bra_ds
braid85822262braid_
brails84621292brails
brains85125472brains
brands95118942brands
cadis84428502cadis
cads76144532ca_ds
caid77837542caid_
cains75334302cains
cairds96411512cairds
canids95118132canids
cards85137932cards
dads67442782da_ds
dais57040702dai_s
drails74716952drails
drains73719402drains
droids84712582droids
druids8368092druids
fads86939882fa_ds
fails85631482fails
fairs85825442fairs
fards96629842fards
fids87034752_fids
frails93716472frails
frauds1036752frauds
gadids95611822gadids
gadis74825292gadis
gads67843392ga_ds
gains65729512gains
gaits65726012gaits
gauds75717722gauds
gids65933752_gids
grads75625752gra_ds
grails77518782grails
grains74223092grains
grands84218242grands
grids75321402grids
guids75516162guids
haiks125120932haiks
hails85231642hails
hairs86225172hairs
halids104016132halids
hands95327382hands
hards96435652hards
ids47535482__ids
imids86015152imids
irids66417782irids
jails125422942jails
kadis105921072kadis
kaifs125715652kaifs
kails95525222kails
kains96125652kains
kids96029652_kids
kraits104912202kraits
lads56549142la_ds
laics76419252laics
laid56439152laid_
lairds74711612lairds
lairs55425872lairs
lands65426902lands
lards65331862lards
lauds65618482lauds
lids56336472_lids
loids66220712loids
mads76845382ma_ds
maid75537672maid_
mails76037782mails
maims96321792maims
mains75635112mains
mairs76228302mairs
mauds85519272mauds
mids76541802_mids
naiads739012naiads
naifs87617422naifs
nails55730402nails
nards65928462nards
oxids13128972oxids
padis86227142padis
pads76742962pa_ds
paid75737492paid_
paiks114719852paiks
pails75833062pails
pains75138282pains
pairs75325832pairs
pards85634332pards
plaids94312442plaids
qadis155917852qadis
qaid146023852qaid_
quids154917472quids
rabid84520782rabid_
rabies85226022rabies
races74943242races
racks115028852racks
rad47662012ra_d_
radii64016412radii
radio64922492radio
radios74018672radios
radish103516922radish
radius73914872radius
radix134414602radix
raffs115017522raffs
rafts87820632rafts
ragas65326062ragas
rages64539442rages
raggs75216472raggs
ragis66325602ragis
rags55448372ra_gs
rai37658222rai__
raia46638382rai_a
raided85017702raided
raider74318742raider
raiders84615142raiders
rail46147762rai_l
rain46251732rai_n
rainy85921082rainy
raise54828052raise
raises64826542raises
raita54623072raita
raitas64417672raitas
rajas127317722rajas
rajes125022782rajes
rakes94440352rakes
rakis95323442rakis
rakus94413672rakus
rales54947492rales
ramies84630462ramies
ramps96224632ramps
rams65950772ra_ms
ramus76418282ramus
rand55839572rand_
randy95022082randy
ranid66429332ranid_
ranis55235842ranis
ranks95225732ranks
rants55935342rants
rapes75740722rapes
rapid86422032rapid_
raps66247732ra_ps
rares55247442rares
ras37575392ra__s
rases55447212rases
rasps74316662rasps
rates55352012rates
ratios64922672ratios
ratos55528762ratos
rats46260372ra_ts
raves85441972raves
ravins94622562ravins
rawins95617622rawins
raws75238212ra_ws
raxes124729392raxes
rayas85922052rayas
rays77642352ra_ys
razes145032702razes
readds84111642readds
reads64835272reads
rebids94015532rebids
redds74617832redds
reds56042872r_eds
reeds65430902reeds
reifs84819092reifs
reins56234562reins
reis45343232rei_s
rends65129952rends
resids74219152resids
rials55026672rials
rias45540602r_ias
ribs65833032r_ibs
rid46754642r_id_
ride55945142r_ide
rides66140822r_ides
rifs74929012r_ifs
rigs55137602r_igs
rims65936312r_ims
rinds64826152rinds
rins46153202r_ins
rips66237442r_ips
roads66523622roads
rods56442072r_ods
roils54826792roils
roods65125282roods
rudds74811702rudds
ruins55822032ruins
rynds9569972rynds
sadis64930852sadis
said55742122said_
sails55738102sails
sains55639972sains
sands65228582sands
sards64736182sards
sayids104310972sayids
skids104615342skids
tads57143952ta_ds
tails55634192tails
tains54936322tains
traiks104013712traiks
trails64622512trails
trains64725342trains
traits65121982traits
triads74513532triads
ursids737822ursids
vails85825932vails
vairs85019132vairs
vids85627552_vids
voids95414682voids
wadis95223962wadis
wads87343152wa_ds
waifs115719872waifs
wails86631482wails
wains86930872wains
wairs86424062wairs
waits88333522waits
wands96425482wands
wards97734402wards
whids125413992whids
yairds10448022yairds
yards95324612yards
yauds95013222yauds
yids85224972_yids

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 Limit538002641.79629955.5
3Display Results2642640.0634190.5
 (SQL Overall)1786912642.15582919.3
 
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.