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

311 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
rail4614776(None) 
ail37171041_ail
aril45843021aril
bail65042801bail
brail75525551brail
drail65020971drail
fail74840241fail
frail85220211frail
grail64622871grail
hail74839061hail
jail115529091jail
kail85131491kail
mail65543431mail
nail45838651nail
pail66141831pail
rai37658221rai_
raia46638381raia
raid55243071raid
rails55937401rails
rain46251731rain
rais45252621rais
rial45938091rial
roil46235291roil
sail45447161sail
tail45443651tail
trail55126771trail
vail75432551vail
wail75238821wail
aal39058672_aal
ai211288392_ai_
aid49269072_aid
ails45654712_ails
aim57858212_aim
ain37579092_ain
air38058392_air
ais39083572_ais
ait38093902_ait
al210674042_a_l
all36148232_all
anil46437432anil
argil65116882argil
aria46245422aria
arid57642712arid
ariel55228972ariel
arils58732202arils
aryl75922342aryl
avail8313882avail
awl67635302_awl
axil116424452axil
baal67033112baal
bails75933522bails
bait66556002bait
bal56662722ba_l
ball66043322ball
basil75122272basil
bawl95326062bawl
boil66335182boil
braid85822262braid
brails84621292brails
brain76229382brain
brasil8713862brasil
brawl106217962brawl
brazil1779622brazil
broil74918222broil
caid77837532caid
cain65643912cain
call66838672call
carl65144782carl
caul65630002caul
cavil103816492cavil
ceil65725062ceil
coil66439652coil
craal74117752craal
crawl104916712crawl
dahl87019222dahl
daily95922332daily
dais57040702dais
dal47554952da_l
deil56231622deil
derail74218812derail
dial55935062dial
drails74716952drails
drain65222892drain
drawl95516012drawl
earl45838142earl
email74715092email
ervil8310302ervil
evil75318072evil
fails85631482fails
fain75840562fain
fair76332522fair
fall75535312fall
farl76338552farl
fil65447142_fil
flail85316182flail
foil76433912foil
frails93716472frails
frazil1847222frazil
gaily95020972gaily
gain56042162gain
gait56150192gait
gal46055512ga_l
gall56335992gall
gaol56925412gaol
graal64316502graal
grails77518782grails
grain65126252grain
haik115526982haik
hails85231642hails
hair76330142hair
hall75741162hall
harl75740002harl
haul75530452haul
heil76328932heil
jails125422942jails
jarl115828132jarl
kaif116933922kaif
kails95525212kails
kain85334292kain
kraal94511822kraal
krait94726772krait
laic65931562laic
laid56439142laid
lain46146282lain
lair45934152lair
lall45531312lall
maid75537632maid
maile75232212maile
maill74420782maill
mails76037772mails
maim85831472maim
main65345502main
mair66133762mair
mall64639362mall
marl66341612marl
maul64830712maul
mil55752102_mil
moil65534082moil
naif76839012naif
nails55730402nails
nil36144192_nil
noil46133242noil
oil37452052_oil
oral47638122ora_l
paid75737482paid
paik105726802paik
pails75833062pails
pain65647242pain
pair66031512pair
pal56761672pa_l
pall65039342pall
pawl95123262pawl
pial65636702pial
qaid146023842qaid
quail144314362quail
rabic93817392rabic
rabid84520772rabid
race66746262race
racial83419242racial
racily11715172racily
rack106234882rack
racy95825682racy
rad47662002ra_d
radial74020392radial
radii64016412radii
radio64922492radio
radix134414592radix
rads56046602rads
raff104933042raff
raft76245912raft
rag45761322ra_g
raga55930812raga
rage55742352rage
ragg65622692ragg
ragi56032282ragi
ragis66325602ragis
rags55448372rags
rah68052402ra_h
raias54631122raias
raids65827512raids
railed74727542railed
railer64524932railer
rains55140232rains
rainy85921082rainy
raise54828052raise
raita54623072raita
raj105740222ra_j
raja117918682raja
rake84841572rake
raki87127832raki
rakis95323442rakis
raku85423772raku
rale45050562rale
rally84725902rally
ram56867272ra_m
ramal74622242ramal
rami66034092rami
ramie75027822ramie
ramp85934002ramp
rams65950772rams
ramtil8311022ramtil
ran38266612ra_n
rand55839562rand
rang56939152rang
rani46640102rani
ranid66429332ranid
ranis55235832ranis
rank85135522rank
rant45864672rant
rap56261962ra_p
rape65041632rape
rapid86422032rapid
raps66247732raps
rapt67245312rapt
rare45348432rare
ras37575392ra_s
rase46149982rase
rash76039932rash
rasp66029162rasp
rat37892742ra_t
ratal55025112ratal
rate45458762rate
ratel54224882ratel
rath76037662rath
ratio55227582ratio
rato45436972rato
rats46260372rats
rave75542092rave
ravel84621512ravel
ravin85624652ravin
raw67252252ra_w
rawin85521472rawin
rawly115115832rawly
raws75238212raws
rax108445722ra_x
ray66361992ra_y
raya75224822raya
rays77642352rays
raze135235432raze
razz125219422razz
real45750292real
reel45240532reel
rei35647252rei_
reif76937642reif
rein46040892rein
reis45343232reis
remail85017122remail
renail65020762renail
reoil55321182reoil
resail64418732resail
retail65522072retail
ria36745502r_ia
rials55026672rials
rias45540592rias
rib56848022r_ib
rid46754622r_id
riel46432382riel
rif65951552r_if
rig46748122r_ig
rile45650532r_ile
rill45140902rill
rim56052272r_im
rin36663182r_in
rip56851302r_ip
roils54826792roils
roily86121112roily
roll46331652roll
rotl45029682rotl
ruin47430512ruin
said55742112said
sails55738102sails
sain45551292sain
sal36462882sa_l
sall44544682sall
saul45836522saul
serail64222672serail
sial45938832sial
snail57020202snail
soil46138822soil
spail74921552spail
swail86217162swail
tael46030712tael
tails55634192tails
tain45548072tain
tali46837162tali
tall47240212tall
til36350262_til
toil46536282toil
traik95418202traik
trails64622512trails
train56529112train
trait56940842trait
trawl84915872trawl
trial54926352trial
uracil8311542uracil
urial54823022urial
vails85825932vails
vain75233002vain
vair75624142vair
vakil1259792vakil
veil75523592veil
vial76731092vial
waif105836742waif
wails86631482wails
wain75840192wain
wair75830052wair
wait75553692wait
wall76236102wall
waul76927312waul
wawl105321942wawl
yawl104918972yawl

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 Filter178691298720.1561145455.1
2DLD Change Limit298723111.50019914.7
3Display Results3113110.0764092.1
 (SQL Overall)1786913111.732103170.3
 
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.