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

169 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
levanting134552(None) 
levantine1264791levantine
decanting132510632decanting
elevating1338202eleva_ting
leaning83721202le_an_ing
legating102313112lega_ting
levantines1364222levantines
recanting122414822recanting
tenanting1036212tenanting
advancing1643063advancing
aerating92821003aera_ting
anting75827023___anting
beaning103820683be_an_ing
beating104326873be_a_ting
bepainting15144883bepainting
berating113220763bera_ting
bleating113514503ble_a_ting
canting104725903__canting
cementing1438763cementing
chanting143413533_chanting
cleaning113112383cle_an_ing
cleansing1235073cle_ansing
cleating113518143cle_a_ting
deaning94020473de_an_ing
debating123213733deba_ting
defanging1535333defanging
defatting1436103defatting
delating103119603dela_ting
demanding14237923demanding
demasting1338453demasting
dementing13311043dementing
denting94422183de__nting
depainting14156153depainting
departing1349513departing
deranging1238063deranging
derating103222283dera_ting
deratting1139513deratting
desalting1138843desalting
desanding12207653desanding
descanting1446923descanting
devaluing1434833devaluing
devesting14249903devesting
deviating14311083deviating
devoting1338823dev_oting
eanling81416673_e_anling
easting84924303_e_asting
eating75134403_e_a_ting
elating83423083_ela_ting
emanating1239003_emanating
enacting11311363_enacting
evading1237283_eva_ding
evening11310223_even_ing
everting122213133_everting
evicting1437483_evicting
evincing1446183_evincing
eviting11511373_ev_iting
exacting1838523_exacting
exalting1638033_exalting
feasting122011323fe_asting
feinting123410833fe_inting
galavanting1652343galavanting
galivanting1642523galivanting
gelating103015733gela_ting
gleaning10269323gle_an_ing
granting103514523_granting
hanting114124483__hanting
hearting12513123he_arting
heating114024323he_a_ting
henting113719653he__nting
incanting1289903incanting
inventing13109973inventing
lamenting1237693lamenting
lancing103314123l__ancing
landing92819323l__anding
lasting84725243l__asting
leaching143012833le_aching
leading93419553le_a_ding
leafing113313583le_a_fing
leaguing1035343le_aguing
leaking123616973le_a_king
leanings94010183le_an_ings
leaping103215993le_a_ping
learning978553le_arning
leashing123310313le_ashing
leasing83920163le_a_sing
leavening1365973leavening
leaving114216853le_a_ving
legatine91311403lega_tine
lending94118533le__nding
leniting9312353le_niting
lensing84015103le__nsing
letting83218533le__tting
levant9314493levant___
levanted1245323levant_ed
levanter1145303levant_er
levanters1254993levanters
levants1037723levant__s
leveeing12265963lev_eeing
leveling122910433lev_eling
levelling13206973levelling
levering122212503lev_ering
levigating1545693levigating
levitating1446653levitating
levying1435873lev__ying
ligating102212283liga_ting
linting83820983l__inting
livening12248153liven_ing
loaning83614833l_oan_ing
locating11311503loca_ting
lunting83817743l__unting
luxating1645613luxa_ting
meaning103918703me_an_ing
negating102012833nega_ting
panting104025423__panting
penancing1436343penancing
planting113515383_planting
pleating112916053ple_a_ting
preventing161210263preventing
quanting1849233_quanting
ranting84025413__ranting
reacting113317893re_acting
rebaiting12311643rebaiting
rebating112418343reba_ting
recaning111416693recan_ing
recasting122414233recasting
redacting13612303redacting
redating102620173reda_ting
regranting1238323regranting
rehanging1437563rehanging
relanding112110923relanding
relating92725443rela_ting
relenting102716773relenting
remanding132211143remanding
remanning12229033remanning
remating112322423rema_ting
reminting122315103reminting
renting84026853re__nting
repainting13128973repainting
repasting122312843repasting
repenting122316553repenting
replanting1338523replanting
rerenting102617663rerenting
resenting102619293resenting
retasting102513413retasting
retinting102215253retinting
revaluing1337303revaluing
revamping1734633revamping
revenging1438083revenging
reverting132315133reverting
revesting132814123revesting
revetting132912633revetting
revolting1339633revolting
revoting12312033rev_oting
scanting113914763_scanting
seating84130683se_a_ting
sedating103014113seda_ting
slanting94115093_slanting
tenting84621153te__nting
truanting1035603truanting
vanning113912463__vanning
vatting113614853__vatting
vaunting12338753__vaunting
venting114218093__venting
wanting114220173__wanting
weaning114117193we_an_ing
weanling12118643we_anling
yeaning113814633ye_an_ing
yeanling12107063ye_anling
yeasting12188923ye_asting

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 Filter1786911486410.500357382.0
2DLD Change Limit1486411697.09320956.0
3Display Results1691690.0762223.7
 (SQL Overall)1786911697.66923300.4
 
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.