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

308 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
levants103772(None) 
levant9314491levant_
bezants1877342bezants
decants103514442decants
deviants1236732deviants
eluants737582eluants
events94814072_events
gelants82611442gelants
leans55536252le_an_s
leant56737782le_ant_
leasts64616412le_asts
lemans85316392leman_s
levanted1245322levanted
levanter1145302levanter
levanters1254992levanters
levins94514652levin_s
lovats939072lova_ts
pedants10310112pedants
recants93217092recants
savants1038652savants
secants93413892secants
servants1138002servants
tenants7311012tenants
advents11309473advents
alants67722023_alants
alevins102110573alevin_s
alleviants1353413alleviants
alterants979103alterants
ants47243473___ants
avant86224663_avant_
beanos85516513be_anos
beans75734693be_an_s
beasts84519723be_asts
beats76042243be_a_ts
beauts86015283be_auts
bents76033693be__nts
bepaints1235113bepaints
bezant17814543bezant_
bezzants1843643bezzants
bleats85518613ble_a_ts
brants85723053_brants
byzants2153223byzants
cants77036943__cants
cements112714223cements
cents74730333ce__nts
cetanes9315133cetanes
chants115020393_chants
cleans85817053cle_an_s
cleats84919313cle_a_ts
deans66131393de_an_s
decanes103118913decanes
decant93524223decant_
dedans85915073dedan_s
defangs1235363defangs
defats105114553defa_ts
demands114311413demands
demasts1089223demasts
dements103016623dements
dents65031803de__nts
depaints1136643depaints
departs104310683departs
derats74625063dera_ts
desalts839573desalts
desands94810163desands
descants112910143descants
detents83615153detents
devas96218883deva__s
devests114410473devests
deviant11311313deviant_
devons104512253devon_s
dewans105215143dewan_s
divans104612393divan_s
dopants1038433dopants
easts57530323_e_asts
eats47054873_e_a_ts
elands74914773_elands
elans55527753_elan_s
elegant8311503elegant_
elements10312173elements
elephants1444803elephants
elevate101110373eleva_te
elevates111110423elevates
elevens1066803eleven_s
eleventh1443773eleventh
elevenths1542473elevenths
elevons1067573elevon_s
elints65816423_elints
eluant6315093eluant_
eluents738703eluents
enacts84012973_enacts
epacts105010393_epacts
errants7410643errants
evades1039023_evades
evanish1337653_evanish
evens84817103_even_s
event85924443_event_
everts94514893_everts
evicts11368553_evicts
exacts15359613_exacts
exalts13328313_exalts
feasts95116093fe_asts
feats86432753fe_a_ts
feints94813873fe_ints
galavants1343943galavants
galivants1344203galivants
gelant72821673gelant_
gellants9308283gellants
gents65729613ge__nts
gerents82612923gerents
giants74713503_giants
gleans75014743gle_an_s
grants73722473_grants
grievants1342353grievants
hants86335403__hants
hearts96218943he_arts
heats85838403he_a_ts
hents87330743he__nts
hexanes17319463hexanes
incants92012803incants
infants102210773infants
invents102812053invents
jeans126022113je_an_s
jurants14379213jurants
lagans75717783lagan_s
laments94314853laments
lands65426903l__ands
lanes54946793l__anes
lasts57731263l__asts
latents75214313latents
lats45962703l__a_ts
lauans65113533lauan_s
lavabos1235453lavabos
lavages1138603lavages
lavas85422223lava__s
leads66028493le_a_ds
leafs85721183le_a_fs
leaks95923913le_a_ks
lealty92910603le_alty
lean46345243le_an__
leaned73422543le_aned
leaner64022193le_aner
leaners73718173le_aners
leanest7415863le_anest
leanly93811503le_anly
leaps75522933le_a_ps
leapt75027473le_apt_
learns65513743le_arns
learnt64019253learnt_
lears55938733le_a_rs
leas45954183le_a__s
leases65428113le_ases
least56134883le_ast_
leavens10409303leavens
leavers103717783leavers
leaves94222383le_aves
leavings12407493leavings
lebens8310093leben_s
leets54927123le__ets
lefts86517813le__fts
legals73412733lega_ls
legate72917453lega_te
legates82917683legates
legato72810953lega_to
legatos82711183legatos
legends936073legends
legists899593legists
legits71313003le_gits
legongs934543legongs
lekvars1432693lekva_rs
leman75622603leman__
lemons84415053lemon_s
lends65326253le__nds
lenes54738523le__nes
lenis56326863le__nis
lenos56024863le__nos
lens46146493le__n_s
lent46360533le__nt_
lento57223393le__nto
lentos65317403le__ntos
leones64417723le_ones
lets47147943le___ts
leva77020713leva___
levantine1264793levantine
levantines1364223levantines
levanting1345523levanting
levator10298963levator
levators11249283levators
levees93714523lev_ees
levels94113283lev_els
leverets11297603leverets
levers94621323lev_ers
leviers103510343leviers
levies93919863lev_ies
levin84816413levin__
levis85818553lev__is
levity1277903lev_ity
lianas63713383l_ianas
lianes63819323l_ianes
liangs74410593l_iangs
libelants1145303libelants
ligands9438983ligands
ligans76817733ligan_s
limans84816303liman_s
lints57137193l__ints
livens94314893liven_s
livings11408923livings
llanos6108333l_lanos
loans56026463l_oan_s
logans76319063logan_s
loments93413473loments
lorans65117603loran_s
lovages1138033lovages
lovat8321043lova_t_
lunts55826903l__unts
means75831233me_an_s
meant76537213me_ant_
meats75034053me_a_ts
mediants11299493mediants
mutants938583mutants
neats55931903ne_a_ts
octants9128733octants
operants1039483operants
pants76536923__pants
pavanes123612653pavanes
pavans115715593pavan_s
peans75437643pe_an_s
peanuts936993pe_anuts
peasants1038263peasants
peats76140193pe_a_ts
pecans101515833pecan_s
pedant9319493pedant_
pekans121710553pekan_s
penangs10268373penangs
pendants1139093pendants
pennants1037063pennants
plants84921803_plants
pleats85218593ple_a_ts
prevents133012293prevents
quants153614143_quants
rants55935343__rants
reacts83616603re_acts
rebaits9312573rebaits
recanes93222263recanes
recant83228683recant_
recasts93413533recasts
redacts10510943redacts
redans75421023redan_s
regents83416543regents
regrants9310013regrants
rehangs1137563rehangs
relands85214883relands
relents74018503relents
relevant1149243relevant_
remands104914883remands
remans84823003reman_s
remints95117293remints
remnants1036843remnants
rents55935183re__nts
repaints1038483repaints
repasts93611933repasts
repents93717623repents
replants102811243replants
rerents73319423rerents
resents74221223resents
retints74717013retints
revamps1433993revamps
revenants1246173revenants
reverts104715043reverts
revests104413733revests
revets94022173rev_ets
revolts1038893revolts
savant9416043savant_
scants85219723_scants
sealants82610743sealants
seats54844343se_a_ts
seawants11337973seawants
secant84023293secant_
sedans74816093sedan_s
sejant133114483sejant_
servant10313633servant_
sevens93813663seven_s
seventh1336773seventh
sevenths1444793sevenths
seventy1338033seventy
sewans95215903sewan_s
sextants15287383sextants
slants64819083_slants
sonants7511233sonants
teats55636813te_a_ts
tenant6322473tenant_
tents56434213te__nts
tetanus737933tetanus
truants738163truants
tyrants1037453tyrants
vanes85130973__vanes
vangs96319583__vangs
vans76236733__van_s
vasts86423773__vasts
vats76841743__va_ts
vaunts95212623__vaunts
vegans103910853vegan_s
vents86125933__vents
versants1137783versants
wants87932213__wants
weans85326743we_an_s
yeans86624883ye_an_s
yeasts96413053ye_asts
zenanas16286233zenanas

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273086.36021073.4
3Display Results3083080.1102800.0
 (SQL Overall)1786913086.87625987.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.