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 “ranted” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

227 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
ranted7432470(None) 
anted66328241_anted
canted94825781canted
granted94715101granted
hanted104124311hanted
panted95024821panted
rafted104714701rafted
ranged84824311ranged
ranked114620741ranked
ranter63826821ranter
rated65441381ra_ted
ratted74923341ratted
rented74426591rented
wanted104319721wanted
acted88521732_acted
ante46538902_ante_
anteed75616112_anteed
antes56334322_antes
baited95319242baited
banded105223172banded
baned85436352ban_ed
banged104923722banged
banked135021442banked
banned94721342banned
banter84825332banter
basted95227232basted
bated85935532ba_ted
batted95623652batted
bracted12410932bracted
branded114414102branded
branned104311692branned
bunted95219182bunted
caned85838092can_ed
canned95022062canned
canoed94618962canoed
canter85230112canter
carted98631442carted
catted95422472catted
chanted134015952chanted
crafted13419772crafted
craned96121652cran_ed
cranked143812842cranked
crated94827772cra_ted
danced105315252danced
danged94819482danged
darted84620922darted
dated75530992da_ted
daunted93810192daunted
dauted84114932dauted
dawted11489682dawted
dented84120512dented
dinted84419842dinted
drafted12439032drafted
dratted9358592dratted
dunted84718502dunted
fainted114211722fainted
fanged114318222fanged
fanned104117472fanned
fantod102010032fantod
farted105121782farted
fasted105320952fasted
fated95632132fa_ted
fatted105419842fatted
fracted1339372fracted
franked153610052franked
fronted114011272fronted
gaited84416922gaited
ganged94619192ganged
gasted84821582gasted
gated75329772ga_ted
grafted124110222grafted
grantee83217132grantee
granter84117132granter
grated84523922gra_ted
grunted9339282grunted
hafted134713832hafted
halted105019602halted
handed114919982handed
hanged114222392hanged
hanked144220602hanked
hasted105125282hasted
hated95734022ha_ted
hatted104921512hatted
haunted11399732haunted
hented104218752hented
hinted104318322hinted
hunted104417012hunted
jaunted15418562jaunted
lanated8313202lanated
lanced93717722lanced
landed84619242landed
lasted74323602lasted
lated65240672la_ted
linted74021822linted
lunted74517522lunted
malted94819862malted
maned86634102man_ed
manned94418642manned
mantel84317972mantel
mantes84430782mantes
mantid93820382mantid
mantled104113392mantled
marted94425212marted
masted94025802masted
mated85537782ma_ted
matted94521412matted
minted94220582minted
orated74221502ora_ted
painted104214632painted
paned85437182pan_ed
panged104722332panged
panned94123432panned
parted94228682parted
pasted94426902pasted
pated85237842pa_ted
patted94724682patted
planted103516122planted
pranced123714042pranced
pranged114512552pranged
pranked143712092pranked
prated94924922pra_ted
printed104016372printed
punted94618712punted
quanted1738962quanted
raced87635312ra_ced
racked134526082racked
radded94716492radded
rafter94517582rafter
raged74829452ra_ged
ragged94620262ragged
raided85017702raided
railed74727542railed
rained75024602rained
raised76120332raised
raked105831422ra_ked
rammed113117302rammed
ramped114617902ramped
rance75028512rance_
rances84625442rances
ranched133113602ranched
rancid9513862rancid
rand55839572ran__d
ranee55438102ran_ee
ranees64623962ranees
range64728412range_
ranger73925522ranger
ranges73826922ranges
ranid66429332ran_id
ranker105021902ranker
rankled123910652rankled
rant45864682rant__
ranters73323642ranters
rants55935342rant_s
raped85334622ra_ped
rapped114122682rapped
rared65738322ra_red
rased65033932ra_sed
rasped94715202rasped
raster64731442raster
rate45458762ra_te_
ratel54224882ra_tel
rater54943282ra_ter
rates55352012ra_tes
ratten64217382ratten
ratter64326312ratter
rattled84012952rattled
raved94931432ra_ved
raxed135622662ra_xed
rayed95127502ra_yed
razed155027982ra_zed
razeed163710012razeed
razzed15478282razzed
reacted103015712reacted
recanted112513512recanted
rended84524102rended
rente54733782rente_
renter64527412renter
rentes65431192rentes
rested74430782rested
retted74826312retted
rifted104115312rifted
rinded84418982rinded
ringed84623842ringed
rinsed75016352rinsed
rioted73416372rioted
roasted83912662roasted
rooted75424002rooted
rotted74524432rotted
routed75624332routed
rusted75020922rusted
rutted74518402rutted
sainted84114242sainted
salted74121202salted
sanded84920612sanded
saned65636272san_ed
sated66238532sa_ted
sauted74119602sauted
scanted104114392scanted
slanted83514742slanted
tainted83512422tainted
tanged84622492tanged
tanked113919292tanked
tanned75219952tanned
tarted74923372tarted
tasted74123972tasted
tatted74920532tatted
taunted84310962taunted
tauted75317112tauted
tented74221002tented
tinted74419532tinted
tranced104414172tranced
truanted935372truanted
vaned94622422van_ed
vanned104614482vanned
vatted104214732vatted
vaunted11438862vaunted
vented104617922vented
wafted134012142wafted
waited103819772waited
waned95831782wan_ed
wanked144517152wanked
wanned104318012wanned
wanter94423052wanter
warted104223232warted
wasted104423022wasted
wonted103213282wonted
yanked144312242yanked

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825512272.64031269.3
3Display Results2272270.0802837.5
 (SQL Overall)1786912273.06358338.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.