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

374 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
talliers8371137(None) 
dalliers93610611dalliers
ralliers84010831ralliers
salliers83613341salliers
tallier72817211tallier_
tallies73624601tallie_s
allies63827672_allie_s
ateliers837882ateliers
ballers94421012ball_ers
ballies93725742ballie_s
callers94221962call_ers
callipers1356492callipers
colliers103613582colliers
dallier84215372dallier_
dallies84023192dallie_s
fallers103917992fall_ers
gallies84122712gallie_s
hauliers1176712hauliers
jolliers15357432jolliers
milliers102611902milliers
pallier94417162pallier_
rallier73816272rallier_
rallies73823342rallie_s
sallier73320422sallier_
sallies73227812sallie_s
saltiers83411952saltiers
tailers73720182tail_ers
talers64628142ta_l_ers
talkers113513212ta_lkers
talkier114011842talkier_
talkies113415732talkie_s
taller63721962tall_er_
tallied83314752tallie_d
tallis63319962talli__s
tallises82713262tallises
talliths11377432talliths
tallits73215992talli_ts
tallness837102tallness
tarriers83411712tarriers
tarsiers8298532tarsiers
tellers73717602tell_ers
tellies73820502tellie_s
tillers73418742till_ers
tollers73217462toll_ers
wallies103320742wallie_s
alders74218423_a_lders
aliens65619213_a_liens
aliners74717723_aliners
alkies104518093_alkie_s
allayers11156633_allayers
allees64521483_all_ees
allegers9378233_allegers
alleys95113303_all_eys
allied74217153_allie_d
alliums957973_alliums
allovers1137673_allovers
allurers8286773_allurers
allures72913113_allures
almners9399563_almners
alters64924223_a_lters
appliers1235573appliers
atelier7311623atelier_
bailers94221353bail_ers
bailies94120203bailie_s
baldies105317703baldie_s
balers85626933ba_l_ers
balkers134915723ba_lkers
balkier134111983balkier_
baller83825203ball_er_
ballets93719513ball_ets
balloters1157673balloters
ballsier1036523ballsier_
balmier113811513balmier_
barriers104311883barriers
bawlers124412733bawl_ers
beliers94617383_beliers
bellies94023723bellie_s
billers94720833bill_ers
billies93923503billie_s
bullier94116433bullier_
bullies94121893bullie_s
cablers114416713cabl_ers
cahiers123510673ca_hiers
calibers1238523calibers
calipers1249443calipers
calkers134414693ca_lkers
callees94117783call_ees
caller85125483call_er_
callets93821703call_ets
callings113613833callings
callipees1345303callipees
calliper1247513calliper_
caloyers1337343caloyers
carriers103614203carriers
cashiers13318883cashiers
caulkers14375653caulkers
cavaliers1455623cavaliers
cavilers1348113cavilers
challies133915643challie_s
claviers1367103claviers
colliders12298073colliders
collier93618153collier_
colliery13307363colliery
collies94326583collie_s
cullers93418853cull_ers
cullies94419963cullie_s
dailies84219263dailie_s
dalles74222063dall_e_s
dallied93713613dallie_d
dellies83622213dellie_s
diallers957773diall_ers
dillies84122163dillie_s
dollies83620983dollie_s
earlier72612743earlier_
fablers124812613fabl_ers
faller94621233fall_er_
falsies103515013falsie_s
falters103916473fa_lters
fanciers13358083fanciers
farriers113610743farriers
fellers104117543fell_ers
fellies104119743fellie_s
fillers104320213fill_ers
fillies103420253fillie_s
fliers94417193__fliers
follies103618943follie_s
fullers103817373full_ers
galilees936333galilees
galleins9258693galleins
gallery11468743gall_ery
gallets83517403gall_ets
galleys11369713gall_eys
galliard10125753galliard
galliards1194543galliards
galliass935423galliass
gallicas1136933gallicas
gallied94115003gallie_d
galliots9228683galliots
galliums1145963galliums
gallopers12136323gallopers
gambiers13337073gambiers
gaolers83511563gaol_ers
gasaliers1044513gasaliers
gaseliers1044923gaseliers
gasoliers1044203gasoliers
gillers84216903gill_ers
gillies84120963gillie_s
glaciers11277893glaciers
glaziers18406563glaziers
gullies84717313gullie_s
hailers104017263hail_ers
halers94926913ha_l_ers
hallels103310133hall_els
halliard12125963halliard
halliards13104933halliards
halloes104021523halloe_s
hallowers15137723hallowers
halters104619803ha_lters
halvers133311423ha_lvers
harriers113712433harriers
haulers104012443haul_ers
haulier1059943haulier_
hellers103619833hell_ers
hillers103718733hill_ers
hillier103413963hillier_
hollers103818233holl_ers
hollies103420813hollie_s
hullers103616263hull_ers
inliers73110743_inliers
jailers144114043jail_ers
jellies143816533jellie_s
jollier142911003jollier_
jollies143516273jollie_s
kellies113516853kellie_s
killers114215583kill_ers
killies113318113killie_s
ladlers84613573ladl_ers
lanciers10308543lanciers
lavaliers1254283lavaliers
liers55130403___liers
lollers72713793loll_ers
lollies73116923lollie_s
lullers73213353lull_ers
mailers94420333mail_ers
mallees93315973mall_ees
mallets93318493mall_ets
malleus92911313mall_eus
mallings113413093mallings
malmier113611953malmier_
maltier93015483maltier_
manlier92414023manlier_
marlier92614773marlier_
marriers103312473marriers
maulers94213303maul_ers
millers93621343mill_ers
millier93716703millier_
milliners11289953milliners
mollies93420233mollie_s
mullers93217303mull_ers
nailers73215893nail_ers
nellies73418723nellie_s
otalgies936393otalgie_s
outliers82610673outliers
palavers1337993palavers
palier85023563pa_lier_
pallets93919303pall_ets
palliest102814633palliest
palliums1236703palliums
pallors9314363pall_ors
palmers113513623pa_lmers
palmier113312173palmier_
palsies94420273palsie_s
palters94021683pa_lters
paniers94717333pa_niers
panniers10488853panniers
parriers103612903parriers
partiers103514243partiers
pliers84715153__pliers
pollers93420023poll_ers
pullers93618483pull_ers
railers74420663rail_ers
rallied83514083rallie_d
rallyes10348553rallye_s
rapiers95012873ra_piers
reliers75519213_reliers
repliers103710163repliers
retallies939373retallie_s
rollers73117473roll_ers
sailers73822323sail_ers
sallets73719653sall_ets
sallied83316953sallie_d
salters73622253sa_lters
saltier74318633saltier_
salties73725773saltie_s
saltires83112423saltires
saluters8319863saluters
salvers103916003sa_lvers
sauciers1076733sauciers
sellers73721323sell_ers
sillers73822103sill_ers
sillier74017593sillier_
sillies73425083sillie_s
soldiers9277773soldiers
spallers102910733spall_ers
stablers103611153stabl_ers
stalkers12369853sta_lkers
stalkier1257073stalkier_
stallions946073stallions
staplers103111203stapl_ers
stillier868823stillier_
sullies74122233sullie_s
tabbies112913503tabbie_s
tabers84621573ta__bers
tables84524893tabl_e_s
tablets94714383tabl_ets
taborers10268333taborers
tackers134319623ta_ckers
tackier133712523tackier_
tacklers143010773tacklers
taffies133012693taffie_s
taggers93514193ta_ggers
taglines92210833taglines
tailer63823733tail_er_
tailings93211673tailings
tailles72516473taille_s
tailless8239083tailless
tailleurs942803tailleurs
tailors73212393tail_ors
takers103923743ta__kers
talars66021683ta_l_ars
taler56034863ta_l_er_
tales55451373ta_l_e_s
talions7314113ta_lions
talipeds1183553talipeds
talipes9611603ta_lipes
talker103916223ta_lker_
talkie103914443talkie__
talkiest123611223talkiest
talkiness1356913talkiness
talkings13358403talkings
tallages92312003tallages
tallboys1374623tallboys
tallest7317093tall_est
tallish103313583talli_sh
tallisim1074983tallisim
tallit63422733talli__t
tallith102913063talli_th
tallithes12286573tallithes
tallitim1065503tallitim
tallols73311363tall_ols
tallows103313743tall_ows
talls55133433tall___s
tallyhos1443333tallyhos
taluses7311213taluse_s
tamers84224033ta__mers
tammies113814683tammie_s
tampers113516743ta_mpers
tanagers9259003tanagers
tangier83013903tangier_
tanglers92911973tanglers
tanglier948073tanglier_
tankers113416913ta_nkers
tanners74018393ta_nners
tansies74521243tansie_s
taperers10269773taperers
tapers84025813ta__pers
tapirs84113173ta_pi_rs
tappers113416543ta_ppers
tapsters10318803tapsters
tardier859719993tardier_
tardies84225863tardie_s
tarrier74323173tarrier_
tarries73324263tarrie_s
tarsier74119253tarsier_
tartier74123263tartier_
tassies74918933tassie_s
tasters74225643ta_sters
tastier711817093tastier_
taters64932203ta__ters
tatters74520483ta_tters
tattier74216243tattier_
tatties74120343tattie_s
tattlers8369693tattlers
taunters8259273taunters
tawers94118603ta__wers
tawnier10318463tawnier_
tawnies102812503tawnie_s
tawpies12309873tawpie_s
taxers134015283ta__xers
taxies135817333ta_xie_s
taxless1436913taxl_ess
telfers10299073t_elfers
teller63519823tell_er_
telphers1335473telphers
terriers84210823terriers
thalers106212263thal_ers
thallious1243273thallious
thalliums1443253thalliums
tidiers8389773t_idiers
tiers55526523t___iers
tilers63523503t_il_ers
tiller64222543till_er_
tillites8312833tillites
tilters73315953t_ilters
toilers74116263toil_ers
tollbars1045443tollbars
toller63819443toll_er_
toolers74416503tool_ers
trailers82912923trail_ers
trawlers113310203trawl_ers
triers64321523t__riers
trillers83613493trillers
trollers83211213trollers
trollies8310233trollie_s
tulles63218893tull_e_s
tullibees1142443tullibees
twiers95410163t__wiers
valleys13407483vall_eys
valuers10328943va_luers
variers103712663va_riers
vaulters11206173vaulters
wailers103916803wail_ers
walers94824463wa_l_ers
walies95324523wa_lie_s
walkers143411473wa_lkers
wallets103914833wall_ets
wallie93216803wallie__
wallopers14136273wallopers
wallowers15127653wallowers
waltzers2034003waltzers
wellies103719073wellie_s
willers103517913will_ers
willies103920153willie_s
yellers103912953yell_ers

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 Filter1786911461620.436409841.7
2DLD Change Limit1461623747.01620832.7
3Display Results3743740.1562397.4
 (SQL Overall)1786913747.60823487.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.