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

368 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
rivaling123991(None) 
rivalling1335961rivalling
dialing94318172di_aling
driveling1445762driveling
frivoling1644492frivoling
ravaging1346322ravaging
raveling123414372raveling
regaling10315362regaling
revaluing1337302revaluing
revealing132611882revealing
reveling123117082reveling
reviling122917212reviling
riddling11249442riddling
ridgling11258202ridgling
riesling939012riesling
riffling1556112riffling
rifling112815012ri_fling
riling74227972ri__ling
rilling84023622ri_lling
rimpling13219662rimpling
rippling13197572rippling
riveting12139442riveting
riving104521422riv__ing
vialing113614162vi_aling
ailing74331013ai__ling
anviling1239743anviling
availing1267283_availing
aviating12311013aviating
baling94829693__baling
beveling143011033beveling
biasing103512453bi_asing
billing103823853bi_lling
birling104317053bi_rling
bivalent1346123bivalent
bridling122610583bri_dling
brigading1445143brigading
brisling112410843bri_sling
bristling1246663bristling
brittling1235543brittling
canaling112016413canaling
caviling14310113caviling
circling1338423circling
coaling103722823_coaling
craaling112711353craaling
crimpling1645343crimpling
crinkling16145863crinkling
crippling1644093crippling
dealing94323233_dealing
devaluing1434833devaluing
develing133212733develing
deviling1311812853deviling
dialings10329823di_alings
dialling10310783dialling
dibbling14247333dibbling
diddling12228743diddling
dilating102714903dilating
dimpling14199023dimpling
dindling112411163dindling
dirling93316073di_rling
disabling1337753disabling
disvaluing1574433disvaluing
divalent1247783divalent
dividing1437183dividing
diving113717953div__ing
divining1338413divining
divulging15103273divulging
divulsing14103933divulsing
divvying1932773divvying
dribbling1533713dribbling
drilling103311983dri_lling
driveline1345353driveline
drivelling1543983drivelling
driving123910713driv__ing
drizzling1943023drizzling
empaling1338363empaling
equaling1837793equaling
evading1237283_evading
exhaling1936293exhaling
fiddling14217873fiddling
filing103823763fi__ling
filling113520803fi_lling
finagling1434703finagling
fixating1936183fixating
fizzling20264993fizzling
foaling113515843_foaling
fribbling1733673fribbling
frilling123011493fri_lling
frivolling1742763frivolling
frizzling2153113frizzling
gaveling133410163gaveling
giggling10227043giggling
gilling93520383gi_lling
gimbaling15134443gimbaling
girdling1146823girdling
giving114313883giv__ing
goaling93515333_goaling
graveling1457383graveling
griddling1333933griddling
grilling103811533gri_lling
grimacing1544033grimacing
grizzling1942843grizzling
groveling1435573groveling
haling104229783__haling
healing113922963_healing
higgling14217163higgling
hilling113821773hi_lling
hireling121210993hireling
hirpling1467223hirpling
hirsling1277543hirsling
hiving134115523hiv__ing
hoveling15189593hoveling
idling8912883_i_dling
imaging1138083_imaging
impaling1338253impaling
inhaling1239523inhaling
inkling122911303_inkling
invading1336263invading
isling71213883_i_sling
jiggling18226363jiggling
jingling17188573jingling
jiving173711603jiv__ing
kibbling17225703kibbling
killing123118723ki_lling
kindling14229623kindling
kitling123313573ki_tling
kittling1336063kittling
kraaling13186663kraaling
leveling122910433leveling
libeling1139873libeling
ligating102212283ligating
livelong1243403livelong
livening12248153livening
livering122012383livering
living104318323liv__ing
medaling121912263medaling
metaling111613723metaling
miauling1137343miauling
middling13249343middling
milling103223683mi_lling
mingling122010933mingling
misalign1146433misalign
misvaluing1684603misvaluing
mizzling19255443mizzling
nibbling13256503nibbling
nickling15278703nickling
nidating1039783nidating
niggling11227443niggling
nilling83619563ni_lling
oiling74925313oi__ling
outrivaling1543753outrivaling
paling93530133__paling
pealing104123203_pealing
pedaling122412133pedaling
pickling17239203pickling
piddling13208953piddling
piffling1745133piffling
piling95025593pi__ling
pilling103722563pi_lling
pindling122110983pindling
pirating11314513pirating
pivoting1436183pivoting
prevailing1656723prevailing
prevaluing1644273prevaluing
prickling1836533prickling
prilling113413413pri_lling
rabbling13239333rabbling
racing95030533r__acing
raddling11229773raddling
raffling1567063raffling
raging85126433r__aging
railing83325643r_ailing
raking114728423r__aking
rambling131810773rambling
rankling132610113rankling
raping94829853r__aping
raring74332873r__aring
rasing74330833r__asing
rassling939013rassling
rating74938703r__ating
rattling92510873rattling
ravelin102211023ravelin_
ravelings13377383ravelings
ravelins113011603ravelins
ravelling13269243ravelling
ravening122611293ravening
raving105128853r__aving
ravining12269693ravining
raxing144321023r__axing
raying105027193r__aying
razing164524543r__azing
reading93327213r_eading
realign838763r_ealign
reaming103924013r_eaming
reaping103621213r_eaping
rearing83128783r_earing
reavailing1444873reavailing
reaving113820533r_eaving
rebating112418343rebating
recalling122211903recalling
recaning111416693recaning
recoaling121312453recoaling
redating102620173redating
reddling112911813reddling
redialing11311843redialing
reedling102414273reedling
reeling83126863r_eeling
refacing142512813refacing
refalling132010423refalling
refiling123116533refiling
reimaging1336503reimaging
reinvading1543823reinvading
reiving113316843reiv__ing
relacing112516043relacing
relating92725443relating
relaxing162612633relaxing
relaying122515153relaying
remailing122412473remailing
remaking152613303remaking
remating112322413remating
renailing102813333renailing
renaming11313693renaming
reoiling93217213reoiling
repaving142810743repaving
repaying142712393repaying
repealing122513543repealing
resailing103314253resailing
resawing122311433resawing
resaying122512453resaying
rescaling122212013rescaling
resealing102115673resealing
resiling93520173resiling
resoling92916303resoling
retailing103214733retailing
retaking133114283retaking
retaping113012553retaping
retaxing162311333retaxing
retiling93319483retiling
revamping1734633revamping
revelling132412553revelling
revering122918073revering
revising122714403revising
reviving152910503reviving
revoking1637803revoking
revolting1339633revolting
revolving1635843revolving
revoting12312033revoting
revving14379343rev_ving
rewaking162310983rewaking
rewaxing19248563rewaxing
ribbing123111953ri_bbing
ricing94822763ri__cing
ricking143920233ri_cking
ridding103314193ri_dding
ridgeling12155263ridgeling
ridging104112983ri_dging
ridglings12214183ridglings
riding84325963ri__ding
rieslings1034493rieslings
riffing144011273ri_ffing
riflings12227303ri_flings
rifting113515003ri_fting
rigging103016333ri_gging
righting132610853righting
riming93322223ri__ming
rimming123411073ri_mming
ringing93521283ri_nging
rinning83216743ri_nning
rinsing82516113ri_nsing
rioting82716393ri_oting
ripening1138573ripening
riping93821613ri__ping
ripping123315743ri_pping
ripsawing1542873ripsawing
rising74025883ri__sing
risking123914243ri_sking
rival85216503rival___
rivaled1138933rival_ed
rivalled1236093rivalled
rivalries1245003rivalries
rivalry1354033rival_ry
rivals94213183rival__s
riverine11310803riverine
rivetting13256413rivetting
roaming103215793r_oaming
roaring82916003r_oaring
rockling15259383rockling
roiling83220453r_oiling
rolling83620413r_olling
rootling9269953rootling
rotating92614553rotating
roving103618743rov__ing
roweling122811123roweling
rubbling13238073rubbling
ruckling15258573ruckling
ruddling11228553ruddling
ruffling1546093ruffling
ruinating1039593ruinating
ruling73219553r__uling
rumbling131910103rumbling
rumpling13178763rumpling
runkling13217613runkling
rustling9249983rustling
savaging1356673savaging
scaling103519373_scaling
sealing83528563_sealing
shealing123415463shealing
shoaling123111753shoaling
shriveling1743253shriveling
sibling10814423si_bling
sickling152910333sickling
sideling101012183sideling
sidling9915423si_dling
signaling1136563signaling
singling101913003singling
sizzling17225783sizzling
skoaling13227213skoaling
sniveling1336033sniveling
spiraling1237953spiraling
staling83925423_staling
stealing93416603stealing
swiveling1634573swiveling
tickling15309433tickling
tiling73426553ti__ling
tilling83522783ti_lling
tingling102210823tingling
tinkling13239233tinkling
tippling13196703tippling
tirling83315733ti_rling
titling83715793ti_tling
totaling9610303totaling
travailing1444613travailing
traveling1349053traveling
triaging102610543tri_aging
trickling1647723trickling
trifling122411503tri_fling
trilling92815963tri_lling
trindling1137133trindling
tripling112712553tri_pling
trivalent1246483trivalent
unbaling11310683unbaling
urinating10310653urinating
vailing113817943__vailing
valine94623093__valine
valuing11298843__valuing
valving14368553__valving
vealing114217423_vealing
vialling1237223vialling
visaing11279333visa_ing
vittling1236143vittling
voling103918023__voling
waling104525303__waling
whaling143910773_whaling
widdling14228743widdling
wiggling14217293wiggling
wildling13248083wildling
wiling103024293wi__ling
willing113821613wi_lling
wimbling16186543wimbling
wimpling16207483wimpling
windling132212263windling
winkling16298293winkling
wintling12249923wintling
witling113215813wi_tling
wiving133316603wiv__ing
wriggling1533813wriggling
wrinkling17144953wrinkling
yealing112716383_yealing
zizzling16233923zizzling

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.596299817.1
2DLD Change Limit1461623687.56019333.6
3Display Results3683680.1432573.4
 (SQL Overall)1786913688.29921531.6
 
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.