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

355 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
rallying1228901(None) 
allying113011661_allying
dallying13368491dallying
gallying13328931gallying
rallyings13313631rallyings
sallying12309851sallying
tallying12318831tallying
allaying12339312_allaying
alloying12339142_alloying
balling104424762ball_ing
bellying14359072bellying
bullying14329292bullying
calling103826772call_ing
collying14319542collying
cullying14297502cullying
dollying13407412dollying
falling113621582fall_ing
galling93921962gall_ing
gillying13306812gillying
gullying13367242gullying
halloing121510072halloing
jellying19306172jellying
jollying19316052jollying
lalling83519622lall_ing
malling103623662mall_ing
palling104024482pall_ing
palsying1436232palsying
railing83325642rail_ing
ralline73518412rall_ine
rallyist1145362rallyist
ralphing1435412ralphing
raying105027192ra__ying
reflying15268172reflying
relaying122515152relaying
relying112914612r_elying
replying14269402replying
retallying1464702retallying
rilling84023622rill_ing
rolling83620412roll_ing
sullying12328512sullying
trollying1354052trollying
walling113520972wall_ing
willying15306712willying
abying124410413_a_bying
ailing74331013_ail_ing
alining81917043_alining
alleging1038473_alleging
allowing12369093_allowing
alluding1036953_alluding
alluring939073_alluring
applying1634653applying
argling92812733argl_ing
arraying1238753arraying
babying1537963ba_bying
bailing103723523bail_ing
balding114015063ba_lding
baling94829693ba_l_ing
balking143717353ba_lking
balloting1238393balloting
ballyrag1443433ballyrag
bandying15218073bandying
baulking1536003baulking
bawling133813863bawl_ing
baying125222583ba__ying
belaying143110603belaying
belling103825073bell_ing
belying133612443_belying
billing103823853bill_ing
bolling103820883boll_ing
brailing113514793brail_ing
brailling1247773brailling
brandying1654883brandying
brawling143210043brawl_ing
braying134416313bra__ying
bulling104324793bull_ing
bullring11388423bullring
cabling124017553cabl_ing
caddying16225063caddying
calking144617783ca_lking
callings113613833call_ings
callusing1236173callusing
calming123915973ca_lming
calquing2035593calquing
calving134113503ca_lving
candying15188993candying
carling103727063carl_ing
carrying14148373carrying
catling104819793catl_ing
caulking1536803caulking
celling103921263cell_ing
claying133614303_claying
cloying133511753_cloying
craaling112711353craal_ing
cradling122411453cradl_ing
crawling143110513crawl_ing
culling103921303cull_ing
dairying1336353dairying
darling93418363darl_ing
delaying133210973delaying
dialling10310783diall_ing
dolling93817373doll_ing
drawling13318673drawl_ing
draying123813843dra__ying
drilling103311983drill_ing
drolling103510763droll_ing
dulling93418273dull_ing
eagling91113603eagl_ing
eanling81416673eanl_ing
fabling133413623fabl_ing
failing113521333fail_ing
fallowing1666433fallowing
fancying1735353fancying
fatling113815683fatl_ing
faulting12237733faulting
faying134521073fa__ying
felling113321133fell_ing
filling113520803fill_ing
flaying143914463_flaying
fleying14329873_fleying
flying134612153__flying
fraying143413433fra__ying
frilling123011493frill_ing
fulling114019703full_ing
gabling113514543gabl_ing
gallein8299043gallein_
galleins9258693galleins
gallerying1543033gallerying
galleting1137633galleting
galloping1356253galloping
galoping1258023galoping
gaoling93314653gaol_ing
gelling93219763gell_ing
gilling93520383gill_ing
gleying12318433_gleying
graying124115883gra__ying
grayling1338003grayl_ing
grilling103811533grill_ing
gulling94019563gull_ing
gullwing13304923gullwing
hailing113820693hail_ing
haling104229783ha_l_ing
halloaing1387033halloaing
hallooing1366343hallooing
hallowing1676943hallowing
haloing113814133ha_loing
halting114419073ha_lting
halving143511543ha_lving
harrying15157643harrying
hauling113714433haul_ing
haying134420613ha__ying
helling114623223hell_ing
helloing12159123helloing
hilling113821773hill_ing
hilloing12158303hilloing
hollaing12167093hollaing
holloing12148823holloing
hulling113619013hull_ing
hulloing12146703hulloing
implying1635533implying
inlaying1247893inlaying
inlying1168153_inlying
jailing153415843jail_ing
jelling153516613jell_ing
killing123118723kill_ing
kraaling13186663kraal_ing
ladling92813393ladl_ing
lallygag1341903lallygag
laying104525703__laying
lazying2046673la_zying
lolling83415773loll_ing
lulling83616803lull_ing
lying95717453___lying
mailing102923343mail_ing
mallings113413093mall_ings
malting103219083ma_lting
marling103322763marl_ing
marrying14157223marrying
mauling103315683maul_ing
maying124421153ma__ying
melling102822623mell_ing
milling103223683mill_ing
misallying1644313misallying
mislying1437843mislying
mulling103819993mull_ing
nailing83419963nail_ing
nilling83619563nill_ing
nulling83818063null_ing
outlying1248813outlying
paling93530133pa_l_ing
palleting1238743palleting
palming123914013pa_lming
palping124112873pa_lping
pandying15217663pandying
parlaying1537303parlaying
parleying1536113parleying
parling103823763parl_ing
parrying14168133parrying
partying14168893partying
paying123722163pa__ying
pilling103722563pill_ing
playing133816093_playing
ploying132811573_ploying
plying124312083__plying
polling102920383poll_ing
praying133717323pra__ying
prilling113413413prill_ing
pulling103821073pull_ing
rabbling13239333rabbling
racing95030533ra__cing
racking144323663ra_cking
radding103715003ra_dding
raddling11229773raddling
radioing1039383radioing
raffling1567063raffling
rafting113815753ra_fting
ragging103516683ra_gging
raging85126433ra__ging
raiding93617593ra_iding
railings93412153rail_ings
raining83922693ra_ining
raising83220533ra_ising
raking114728423ra__king
rallied83514083rall_ied
rallier73816273rall_ier
rallies73823343rall_ies
rally84725903rally___
rallye95110163rally__e
rallyes10348553rally_es
rallyists1243333rallyists
rambling131810773rambling
ramifying1855603ramifying
ramming123115063ra_mming
ramping123316873ra_mping
ranching141712043ranching
ranging94120263ra_nging
ranking124320883ra_nking
rankling132610113rankling
ranting84025413ra_nting
raping94829853ra__ping
rapping123619103ra_pping
rarefying1654693rarefying
rarifying1646313rarifying
raring74332873ra__ring
rasing74330833ra__sing
rasping104316253ra_sping
rassling939013rassling
ratifying1656823ratifying
rating74938703ra__ting
ratlin64116523ratl_in_
ratline74517803ratl_ine
ratlins73615583ratl_ins
ratting83822363ra_tting
rattling92510873rattling
ravaging1346323ravaging
raveling123414373raveling
ravelling13269243ravelling
ravening122611293ravening
raving105128853ra__ving
ravining12269693ravining
raxing144321023ra__xing
razeeing1834363razeeing
razing164524543ra__zing
razoring1836443razoring
razzing1636323ra_zzing
readying13410223readying
realising10313173realising
realizing19313813realizing
reapplying1843023reapplying
rebuying1436743rebuying
recalling122211903recall_ing
redrying13209023redrying
reeling83126863reel_ing
refalling132010423refall_ing
refrying15278903refrying
regluing1077033regluing
reifying1539383reifying
rekeying1637563rekeying
relacing112516043relacing
relating92725443relating
relaxing162612633relaxing
relining93218743relining
reliving122713343reliving
reluming11310013reluming
repaying142712393repaying
replaying15259603replaying
resaying122512453resaying
retrying122410453retrying
retying113213833r_etying
rifling112815013rifl_ing
riling74227973r_il_ing
rivalling1335963rivall_ing
roiling83220453roil_ing
rolfing113710653r_olfing
rollings9419953roll_ings
rubying13297933r_ubying
ruling73219553r_ul_ing
sailing83927373sail_ing
salarying1336073salarying
salifying1636333salifying
sallowing1357383sallowing
salting84120793sa_lting
saluting9310553saluting
salving113913153sa_lving
salvoing1236423salvoing
sapling103217863sapl_ing
savvying1862723savvying
saying104325543sa__ying
selling83225833sell_ing
slaying113316843_slaying
spalling113213463spall_ing
splaying14219303splaying
stalling95116703stall_ing
tabbying1633973tabbying
tabling103216033tabl_ing
tailing82923103tail_ing
talcing103111633ta_lcing
talcking1567083talcking
talking123815823ta_lking
tallaging1146493tallaging
tallowing1366293tallowing
tallyhoing1741583tallyhoing
tarrying12146723tarrying
taxying1836183ta_xying
telling83321083tell_ing
thralling13256833thrall_ing
tilling83522783till_ing
tolling83418563toll_ing
trailing92916093trail_ing
trawling122710783trawl_ing
trilling92815963trill_ing
trolleying1442553trolleying
trolling93212493troll_ing
unlaying1258363unlaying
vailing113817953vail_ing
valeting1238853valeting
valuing11298843va_luing
valving14368553va_lving
varying1429723va_rying
vaulting12227233vaulting
vialling1237223viall_ing
volleying1643763volleying
waddying17204723waddying
wailing113620903wail_ing
waling104525303wa_l_ing
walking154013303wa_lking
walloping1545593walloping
wallowing1666073wallowing
waltzing2134263waltzing
wauling112713113waul_ing
wawling143810963wawl_ing
waylaying1953103waylaying
welling112920313well_ing
willing113821613will_ing
yawling14369183yawl_ing
yelling113516703yell_ing

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 Limit1461623556.64322002.4
3Display Results3553550.1402535.7
 (SQL Overall)1786913557.21924752.9
 
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.