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 “ralliers” 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
ralliers8401083(None) 
dalliers93610611dalliers
rallier73816271rallier_
rallies73823341rallie_s
salliers83613341salliers
talliers83711371talliers
allies63827672_allie_s
ballers94421012ball_ers
ballies93725742ballie_s
callers94221962call_ers
callipers1356492callipers
colliers103613582colliers
dallier84215372dallier_
dallies84023192dallie_s
fallers103917992fall_ers
gallies84122712gallie_s
hauliers1176712hauliers
jolliers15357432jolliers
milliers102611902milliers
pallier94417162pallier_
railers74420662rail_ers
rallied83514082rallie_d
rallyes10348552rallye_s
rapiers95012872ra_piers
reliers75519212r_eliers
repliers103710162repliers
rollers73117472roll_ers
sallier73320422sallier_
sallies73227812sallie_s
saltiers83411952saltiers
tallier72817212tallier_
tallies73624602tallie_s
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
ateliers837883ateliers
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
braillers1135553braillers
brasiers103710513bra_siers
brawlers13408643brawl_ers
brawlier13267043brawlier_
braziers19397193bra_ziers
brollies1039533brollie_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
cradlers11309203cradl_ers
crawlers13309013crawl_ers
crawlier13216873crawlier_
crullers1047303crull_ers
cullers93418853cull_ers
cullies94419963cullie_s
dailies84219263dailie_s
dalles74222063dall_e_s
dallied93713613dallie_d
dellies83622213dellie_s
diallers957773diall_ers
dillies84122163dillie_s
dollies83620983dollie_s
drawlers12307313drawl_ers
drawlier12225253drawlier_
drillers9429723drill_ers
earlier72612743earlier_
fablers124812613fabl_ers
faller94621233fall_er_
falsies103515013falsie_s
falters103916473fa_lters
fanciers13358083fanciers
farriers113610743farriers
fellers104117543fell_ers
fellies104119743fellie_s
fillers104320213fill_ers
fillies103420253fillie_s
fliers94417193__fliers
follies103618943follie_s
frillers11349873frill_ers
frillier1136513frillier_
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
graziers18387123gra_ziers
grillers93810813grill_ers
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
krullers1234133krull_ers
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
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
rabbies113416053rabbie_s
rabbiters1343733rabbiters
rabblers123810853rabblers
rabies85226023ra_bie_s
racers84725433ra__cers
racier85120973ra_cier_
rackers134320453ra_ckers
rafflers14317363rafflers
rafters103715633ra_fters
raggies93214733raggie_s
raiders84615143ra_iders
railcars1045313railcars
railer64524933rail_er_
railings93412153railings
raillery1134953raillery
rainier71614263rainier_
raisers73617393ra_isers
rakers104123573ra__kers
rales54947493ra_l_e_s
ralliform1443163ralliform
ralline73518413ralli_ne
rallye95110163rallye__
rallyings13313633rallyings
rallyists1243333rallyists
ramblers124010373ramblers
ramies84630463ra_mie_s
ramilies10311833ramilie_s
ramillies1146133ramillie_s
rammers113715043ra_mmers
rammier112811023rammier_
ranchers133311793ranchers
randier83618473randier_
randies84225663randie_s
rangers83621043ra_ngers
rangier83714353rangier_
rankers113217463ra_nkers
ranters73323643ra_nters
rapers84327183ra__pers
rapier84019993ra_pier_
rappers113618443ra_ppers
rarefiers1244023rarefiers
rasers64526783ra__sers
rashers104020913ra_shers
raspers94415923ra_spers
raspier93110643raspier_
rasters74629023ra_sters
raters63936583ra__ters
ratifiers1236453ratifiers
ratlines83815293ratlines
ratlins73615583ratli_ns
ratters74422473ra_tters
rattier74015593rattier_
rattlers83510293rattlers
ravagers1235583ravagers
ravelers113310863ravelers
ravellers12257163ravellers
raveners11309133raveners
ravers94628183ra__vers
rayless10239003rayl_ess
razers154919613ra__zers
realisers9248323realisers
realizers18237933realizers
realters83614043realters
realties8514853realtie_s
recallers1137103recall_ers
recliners11279113recliners
redliners10267853redliners
reelers73520273reel_ers
reflies104418533reflie_s
reifiers11309843reifiers
relaters83218153relaters
relaxers15298263relaxers
reliefs10439433r_eliefs
relier65826183r_elier_
relies65036423r_elie_s
rentiers83311763rentiers
replier94214973replier_
replies94521043replie_s
retallies939373retallie_s
revilers114011693revilers
ribiers9319753r_ibiers
riflers103512193rifl_ers
rilles64725503rill_e_s
rillets74216153rill_ets
roilier7311523roilier_
rolfers104011813r_olfers
roller63919793roll_er_
rollicks1444893rollicks
rollings9419953rollings
rollovers1244093rollovers
rulers64317093r_ul_ers
rulier65016353r_ulier_
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
sullies74122233sullie_s
tailers73720183tail_ers
talers64628143ta_l_ers
talkers113513213ta_lkers
talkier114011843talkier_
talkies113415733talkie_s
taller63721963tall_er_
tallied83314753tallie_d
tallis63319963talli__s
tallises82713263tallises
talliths11377433talliths
tallits73215993talli_ts
tallness837103tallness
tarriers83411713tarriers
tarsiers8298533tarsiers
tellers73717603tell_ers
tellies73820503tellie_s
tillers73418743till_ers
tollers73217463toll_ers
trailers82912923trail_ers
trawlers113310203trawl_ers
trillers83613493trill_ers
trollers83211213troll_ers
trollies8310233trollie_s
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 9 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.51619446.8
3Display Results3743740.1402671.4
 (SQL Overall)1786913748.09222082.4
 
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.