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

139 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
rivalling133596(None) 
rivaling1239911riva_ling
dialling10310782di_alling
drivelling1543982drivelling
frivolling1742762frivolling
ravelling13269242ravelling
recalling122211902recalling
refalling132010422refalling
revaluing1337302revaluing
revelling132412552revelling
rilling84023622ri__lling
vialling1237222vi_alling
anvilling1336833anvilling
appalling1444923appalling
availing1267283_availing
balling104424763__balling
befalling15226503befalling
begalling13216493begalling
bevelling15227453bevelling
billing103823853bi__lling
caballing1436883caballing
calling103826773__calling
canalling1239553canalling
cavilling1536383cavilling
devaluing1434833devaluing
devilling1436703devilling
dialing94318173di_a_ling
diallings1134993di_allings
disabling1337753disabling
disvaluing1574433disvaluing
divulging15103273divulging
divulsing14103933divulsing
drilling103311983dri__lling
driveling1445763driv_eling
drywalling1842233drywalling
equalling1945243equalling
falling113621583__falling
filling113520803fi__lling
finagling1434703finagling
frilling123011493fri__lling
frivoling1644493friv_oling
galling93921963__galling
gavelling14286873gavelling
gilling93520383gi__lling
gimballing16202923gimballing
gravelling1565213gravelling
grilling103811533gri__lling
grovelling1554163grovelling
hilling113821773hi__lling
hovelling1636163hovelling
infalling1356243infalling
inwalling1385633inwalling
killing123118723ki__lling
kvelling16146513_kvelling
lalling83519623__lalling
levelling13206973levelling
libelling1236873libelling
malling103623663__malling
medalling1346923medalling
metalling1249593metalling
miauling1137343mi_auling
milling103223683mi__lling
misallying1644313misallying
miscalling1547863miscalling
misvaluing1684603misvaluing
nilling83619563ni__lling
outrivalling1651703outrivalling
palling104024483__palling
pedalling1346663pedalling
pilling103722563pi__lling
pinballing1544013pinballing
prevailing1656723prevailing
prevaluing1644273prevaluing
prilling113413413pri__lling
railing83325643r__ailing
ralline73518413r__alline
rallying12289013r__allying
ravaging1346323rava_ging
raveling123414373rav_eling
ravellings14214453ravellings
reavailing1444873reavailing
rebelling122111163rebelling
rebilling12228833rebilling
redialling1246203redialling
refelling132211313refelling
refilling13299333refilling
regaling10315363rega_ling
remailing122412473remailing
renailing102813333renailing
repelling122312753repelling
repolling122110203repolling
rerolling102210373rerolling
resailing103314253resailing
reselling102213833reselling
retailing103214733retailing
retallying1464703retallying
retelling102112493retelling
revamping1734633revamping
revealing132611883revealing
reveling123117083rev_eling
reviling122917213rev_iling
revolting1339633revolting
revolving1635843revolving
riddling11249443ri_ddling
ridgeling12155263ridgeling
ridgling11258203ri_dgling
riesling939013ri_esling
riffling1556113ri_ffling
rifling112815013ri__fling
riling74227973ri___ling
rimpling13219663ri_mpling
rippling13197573ri_ppling
rivalled1236093rivall_ed
rivalries1245003rivalries
riveting12139443riv_eting
rivetting13256413rivetting
riving104521423riv___ing
rolling83620413r__olling
rowelling1366993rowelling
shrivelling1842213shrivelling
signalling1243803signalling
snivelling1444293snivelling
spalling113213463_spalling
spiralling1343963spiralling
squalling1935173squalling
stalling95116703_stalling
swivelling1743413swivelling
thralling13256833thralling
tilling83522783ti__lling
totalling1036523totalling
travailing1444613travailing
travelling1456533travelling
trilling92815963tri__lling
vailing113817943__vailing
valuing11298843__valuing
valving14368553__valving
vialing113614163vi_a_ling
walling113520973__walling
willing113821613wi__lling

Search took 7 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411396.23323847.4
3Display Results1391390.0761828.9
 (SQL Overall)1786911396.73226543.5
 
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.