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

172 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
rivalled123609(None) 
rivaled1138931riva_led
bivalved1742682bivalved
dialled9510132di_alled
drivelled1443982drivelled
frivolled1642382frivolled
ravelled12419782ravelled
recalled11310802recalled
revalued1237022revalued
revelled123712732revelled
rilled74525652ri__lled
unrivalled1443242unrivalled
vialled1156842vi_alled
anvilled1236483anvilled
appalled1344813appalled
availed1135973_availed
balled94926893__balled
begalled1236023begalled
bevelled14327793bevelled
billed94224903bi__lled
bivalve1543593bivalve_
bivalves1643383bivalves
caballed1337163caballed
called94126733__called
canalled1139573canalled
cavilled1436733cavilled
crevalle1346163crevalle_
crevalles1455723crevalles
devalued1335013devalued
devilled1336743devilled
dialed84716453di_a_led
diallel845683di_allel
dialler848813di_aller
dilled84122223di__lled
disabled1248713disabled
disvalued1444193disvalued
divulged1442963divulged
divulsed1343883divulsed
drilled94711673dri__lled
drivable1438023drivable_
driveled1374973driv_eled
driveller1353853driveller
drywalled1741833drywalled
equalled1834863equalled
filled104922263fi__lled
finagled13205293finagled
frilled113911603fri__lled
frivoled1534043friv_oled
frivoller1542433frivoller
galled84622863__galled
gavelled13387363gavelled
gilled84521633gi__lled
gimballed1542673gimballed
gravelled1475553gravelled
grilled94012833gri__lled
grovelled1454183grovelled
hilled104022223hi__lled
hovelled15146843hovelled
inwalled1275773inwalled
killed113918773ki__lled
kvelled15276063_kvelled
lalled74218753__lalled
levelled12327443levelled
libelled11317213libelled
livable122010323livable_
malled94626113__malled
medalled1246893medalled
metalled1148983metalled
miauled1036663mi_auled
milled94326173mi__lled
misallied1246543misallied
miscalled1447443miscalled
misvalued1544283misvalued
muralled1136423muralled
nilled73919453ni__lled
outrivalled1551733outrivalled
palled94625163__palled
pedalled1246923pedalled
petalled1138693petalled
pilled94222753pi__lled
pinballed1444033pinballed
prevailed1536043prevailed
prevalued1544553prevalued
prilled104712993pri__lled
railed74727543r__ailed
rallied83514083r__allied
ravaged1236493rava_ged
raveled114113633rav_eled
raveller11339263raveller
reavailed1344003reavailed
rebelled113110323rebelled
rebilled11318053rebilled
recaller1039323recaller
redialled1145883redialled
refallen1136213refallen
refelled122810163refelled
refilled12278673refilled
regaled93615963rega_led
remailed112411403remailed
renailed92512803renailed
repelled113111573repelled
repolled11359623repolled
rerolled93010043rerolled
resailed93613063resailed
retailed94113963retailed
retallied1046783retallied
revalue1038153revalue_
revalues1137883revalues
revamped1634143revamped
revealed123211213revealed
reveled113917753rev_eled
reveller112912183reveller
reviled114417923rev_iled
revolted12319863revolted
revolved15328103revolved
revulsed1235443revulsed
ribald9209293riba_l_d
ridable101412493ridable_
riddled103012043ri_ddled
riffled14338603ri_ffled
rifled104115003ri__fled
riled65833253ri___led
rille55728733ri__lle_
rilles64725503ri__lles
rillet64828853ri__llet
rimpled123311423ri_mpled
rippled123110273ri_ppled
rivage1038843riva_ge_
rivages1138873riva_ges
rival85216503riva_l__
rivaling1239913rivaling
rivalling1335963rivalling
rivalries1245003rivalries
rivalry1354033riva_lry
rivals94213183riva_l_s
rived94825613riv___ed
riverbed14245143riverbed
riveted11258573riv_eted
rivetted12226093rivetted
rivulet1069723riv_ulet
rolled74220243r__olled
rowelled1236633rowelled
sepalled1156903sepalled
shrivelled1742373shrivelled
signalled1143843signalled
snivelled1353993snivelled
spalled103113133_spalled
spiralled1244403spiralled
squalled1835943squalled
stalled83515683_stalled
swivelled1662963swivelled
thralled1245803thralled
tilled74722953ti__lled
totalled935843totalled
travailed1344223travailed
travelled1356863travelled
trilled84116313tri__lled
trivalve1443943trivalve_
trivalves1544143trivalves
uncalled11810923uncalled
ungalled1078463ungalled
univalved1643483univalved
unrivaled1345243unriva_led
unvalued1266313unvalued
unwalled1288653unwalled
vailed104619293__vailed
valley124311603__valley
valued104011153__valued
valved136711043__valved
vialed105112593vi_a_led
walled104021293__walled
willed104722453wi__lled

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621726.59622159.2
3Display Results1721720.0762263.2
 (SQL Overall)1786911726.82526181.8
 
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.