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 “tallol” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

412 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
tallol6361222(None) 
tallols73311351tallols
tallow93714201tallow
aldol61212332_aldol
allod64418372_allod
allot54933872_allot
allow85420662_allow
alloy85519972_alloy
allyl85310542_allyl
ballon84117492ballon
ballot84624092ballot
callow114714662callow
fallal93612692fallal
fallow124713852fallow
gallon73715812gallon
gallop93311382gallop
hallal94415562hallal
hallel93514092hallel
hallo85127552hallo_
halloa94918122halloa
halloo95118972halloo
hallos95425102hallos
hallot95426782hallot
hallow124818322hallow
mallow114014742mallow
maltol8310842maltol
pallor8313672pallor
sallow94315752sallow
salol55222142sa_lol
tailor63412502tailor
talion6317712talion
tall47240212ta_l_l
tallboy1265132tallboy
taller63721962taller
tallis63319962tallis
tallit63422732tallit
tallows103313732tallows
tallowy13347632tallowy
talls55133432tall_s
tally84526862tall_y
talon55824112ta_lon
taxol124011362ta_xol
toluol636902toluol
wallop113310292wallop
wallow123913512wallow
aglow94711963_aglow
aldols7109713_aldols
algal66518213_algal
algor6513053_algor
alkyl12518043_alkyl
all36148233_a_l_l
allay85620393_allay
allee54932123_allee
allele64514563_allele
alley85721673_alley
allods73615083_allods
allots64019173_allots
allows94517683_allows
alloys94014563_alloys
alls46740923_all_s
ally76935643_all_y
allyls9437273_allyls
aloe45540193_a_loe
aloof83521573_aloof
alow75328593_a_low
also46423443_also_
alto47831263_alto_
altos55822953_altos
argol65317263_argol
atlatl637873atlatl
atoll57913923atol_l
awol75620673_a_wol
azlon144312873_azlon
babool103012153babool
bailor83412603bailor
balboa10389963balboa
ball66043323ba_l_l
ballad94315323ballad
balled94926893balled
baller83825203baller
ballet84733973ballet
ballons93916953ballons
balloon93711433balloon
ballots94116033ballots
balls76236413ball_s
ballsy11508873ballsy
bally105530103ball_y
barlow112911423barlow
bellow114213353bellow
billon83713823billon
billow114111223billow
bollox1548743bollox
call66838673ca_l_l
calla74827073call_a
callan83619603callan
callas84526753callas
callboy1465833callboy
called94126733called
callee84327293callee
caller85125483caller
callet84536763callet
callose9313663callose
callous93516603callous
calls75634733call_s
callus85317073callus
calo64936443ca_lo_
calos74431903ca_los
carol75128613ca_rol
cello74919583cello_
cellos84517803cellos
challot123613263challot
collop107312313collop
dalles74222063dalles
dally95324743dall_y
dalton7311273dalton
diallel845683diallel
dollop9259363dollop
etalon648973eta_lon
falcon11310293falcon
fall75535313fa_l_l
fallals103310193fallals
fallen93813373fallen
faller94621233faller
falloff1245953falloff
fallout10313503fallout
fallows133713973fallows
falls85727653fall_s
felloe93513923felloe
fellow123712743fellow
fillo84319783fillo_
fillos94415073fillos
follow124010353follow
galiot72322583galiot
gall56335993ga_l_l
galled84622853galled
galleon8278713galleon
gallet73630853gallet
galley104215453galley
gallfly1433523gallfly
gallic9411633gallic
galliot82214133galliot
gallons83015943gallons
galloon82910643galloon
galloot82814223galloot
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
galls64729323gall_s
gallus74313203gallus
gally95026173gall_y
galoot72719153galoot
galop84716213ga_lop
gambol1138223gambol
gaol56925413ga__ol
halal85623593ha_lal
hall75741163ha_l_l
hallah124115403hallah
hallels103310133hallels
halloas104318463halloas
halloed113314913halloed
halloes104021523halloes
halloos103716743halloos
halloth134111253halloth
hallows134417393hallows
halls85633783hall_s
hallux1637363hallux
halo76437323ha_lo_
halon86124863ha_lon
halos85230253ha_los
harlot94422803harlot
hello86522983hello_
hellos95321683hellos
hillo84721653hillo_
hilloa94713033hilloa
hillos94618883hillos
hollo84822163hollo_
holloa94914823holloa
holloo94415253holloo
hollos95320633hollos
hollow124212663hollow
hullo84417453hullo_
hulloa95011183hulloa
hulloo94511733hulloo
hullos94916293hullos
jailor13418573jailor
jalop144212603ja_lop
jello126716273jello_
jellos134714283jellos
lall45531313la_l_l
lallan63414173lallan
lalled74218753lalled
lalls55324133lall_s
loll46128383__loll
lollop8238783lollop
maill74420793mail_l
maillot9312173maillot
mall64639363ma_l_l
malled94626103malled
mallee84525593mallee
mallei84414633mallei
malleoli1054053malleoli
mallet84433053mallet
mallows123714323mallows
malls76233433mall_s
maltols939403maltols
mellow114112223mellow
paleal84716673paleal
pall65039343pa_l_l
palled94625163palled
pallet84232653pallet
pallia83015593pallia
pallial92911253pallial
pallid93915273pallid
pallors9314353pallors
palls74332563pall_s
pally105727123pall_y
palpal104112053palpal
parlor8312673parlor
parol74826273pa_rol
patrol83213023patrol
pillow113110573pillow
polyol1138713polyol
rally84725903rall_y
rallye95110163rallye
reallot7312133reallot
safrol937283safrol
sailor63113743sailor
salal55425703sa_lal
sall44544683sa_l_l
sallet63734543sallet
sallowly14344833sallowly
sallows103915543sallows
sallowy13369343sallowy
sally85129713sall_y
salmon84614183salmon
salols64017873salols
salon55228553sa_lon
saloon64418023saloon
saloop84212583saloop
salvo84415643salvo_
salvor94711093salvor
salvos94613383salvos
santol64515243santol
sawlog1035793sawlog
scallop11237643scallop
shallop12348453shallop
shallot103614133shallot
shallow13388873shallow
slalom888173slalom
stall54722353sta_l_l
stalled83515683stalled
stallion837503stallion
stalls64019923stall_s
stanol6310723sta_nol
swallow13355753swallow
tabla73318363tabl_a
tablas83716163tablas
table75429603tabl_e
tabled94020043tabled
tables84524883tables
tablet84227643tablet
tabloid1048253tabloid
taboo73418093ta_boo
taboos83815423taboos
tabor75518393ta_bor
taco67031353ta_co_
tacos77023553ta_cos
tadpole1036143tadpole
tael46030713ta__el
taels56822073tael_s
tahsil936343tahsil
tail45443653ta__il
tailed74424663tailed
tailer63823733tailer
taille63116923taille
tailles72516473tailles
tailors73212383tailors
tails55634193tail_s
tala45938053ta_l_a
talar56225383ta_lar
talars66021683talars
talas55935893ta_las
talc66226813ta_l_c
talced93811003talced
talcky15294723talcky
talcose938133talcose
talcous939483talcous
talcs74817183ta_lcs
talcum1036953talcum
tale46154163ta_l_e
talent6323323talent
taler56034863ta_ler
talers64628143talers
tales55451373ta_les
tali46837163ta_l_i
talions7314093talions
talipot949723talipot
talk86230093ta_l_k
talked114015403talked
talker103916223talker
talkie103914443talkie
talks94322693ta_lks
talky126215683ta_lky
tallage82712073tallage
tallboys1374613tallboys
tallest7317093tallest
tallied83314753tallied
tallier72817213tallier
tallies73624603tallies
tallish103313583tallish
tallith102913063tallith
tallits73215993tallits
tallowed12157713tallowed
tallyho1343043tallyho
tallyhos1443333tallyhos
talons64019423talons
talooka1143493talooka
taluk94812873ta_luk
taluka10426773taluka
taluks10418283taluks
talus55423263ta_lus
tamal73522613ta_mal
tampon102911233tampon
tango66921173tango_
tangos74216303tangos
tannoy958353tannoy
tanto55724943tanto_
tao38358953ta__o_
taos45541003ta__os
tapalo839793tapalo_
tapalos938813tapalos
taphole1239773taphole
tardo65321103tardo_
tarnal63716503tarnal
taro46846913ta_ro_
taroc75721643ta_roc
tarok97921073ta_rok
taros55640823ta_ros
tarot55943933ta_rot
tarpon82812803tarpon
tarsal63315273tarsal
tassel66014773tassel
tatsoi637263tatsoi
tattoo6310973tattoo
tauon54816583ta_uon
tautog765713tautog
taxols13328633taxols
taxon124414663ta_xon
teflon937453teflon
telco7511873telco_
telcos8710683telcos
telial65815363telial
tell44934703t_el_l
teller63519813teller
tells55828943tell_s
telly84920823tell_y
tellys9348843tellys
teloi54217383t_eloi
telos55424523t_elos
telson6310293telson
thalli958913thall_i
thallic1246543thallic
thalloid1246263thalloid
thallous1136523thallous
thallus1035603thallus
theelol1044273theelol
thill85918733thil_l
thiol87616043t_hiol
tholoi9339223tholoi
tholos94213003tholos
thymol1434463thymol
tiglon737913tiglon
till45941203t_il_l
tilled74722953tilled
tiller64222533tiller
tills54631703till_s
timolol944113timolol
toll45535263t_ol_l
tolled73819033tolled
toller63819443toller
tolls54728433toll_s
toluole736113toluole
toluols735823toluols
toluyl933443toluyl
tolyl84710093t_olyl
tool46735683t__ool
trill55122933tril_l
triol55521363t_riol
troll54416533trol_l
trollop944793trollop
trull54012673trul_l
tulle54019933tull_e
tulles63218893tulles
twill85612723twil_l
valley124311603valley
valor83614893va_lor
valval12398863valval
wadmol1234053wadmol
wall76236103wa_l_l
walla85321033wall_a
wallah124011993wallah
wallas95719393wallas
walled104021293walled
wallet93327093wallet
wallie93216803wallie
wallops123410413wallops
wallows133613533wallows
walls85529383wall_s
wally114625093wall_y
willow12369693willow
xylol1546133_xylol
yellow12429883yellow

Search took 8 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127164126.75016698.7
3Display Results4124120.1402942.9
 (SQL Overall)1786914127.03325407.5
 
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.