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

254 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
sealant7311830(None) 
sealants82610741sealants
seawant103613411seawant
alant55742292__alant
gelant72821672ge_lant
gellant83214052gellant
peasant9314922peasant
replant93318532replant
saltant7316772s_altant
savant9416042s_avant
sealift10312792sealift
sealing83528562sealing
seaman84015902seaman_
seaplane1049162seaplane
seawan94111222seawan_
seawans10379942seawans
seawants11337972seawants
secant84023292se_cant
sejant133114482se_jant
sejeant1489722sejeant
servant10313632servant
sextant142911962sextant
slant55238702s__lant
statant7313122statant
adamant101110443adamant
alan46844083__alan_
aland65526413__aland
alane56135613__alane
alang66023513__alang
alans55636173__alans
alants67722023__alants
ashplant1345413ashplant
aslant6317753_aslant
assailant944383assailant
avant86224663__avant
bezant17814543be_zant
bezzant1746893bezzant
blatant9310673blatant
callant94121223callant
clamant11312433clamant
coolant9316463coolant
dealate83617843dealate
dealing94323233dealing
dealt65234283deal__t
decant93524223de_cant
defiant11311923defiant
deplane10311413deplane
descant104315593descant
deviant11311313deviant
eclat7523603_ecla_t
elan46734243_e_lan_
eland65820393_e_land
elans55527753_e_lans
elint55436473_e_lint
eluant6315093_eluant
emanant9411093emanant
errant6618733_errant
exhalant1895353exhalant
explant16310133explant
extant132714753_extant
fenland1135693fenland
gallant83517113gallant
gelants82611443ge_lants
gellants9308283gellants
headland1345613headland
healing113922963healing
implant11311333implant
inhalant1147403inhalant
jessant1438443jessant
leadplant1244073leadplant
leant56737783le__ant
learnt64019253lea_rnt
levant9314493le_vant
meant76537213me__ant
mediant103516703mediant
natant6318733_natant
osculant1046953osculant
pealing104123203pealing
peasants1038263peasants
peccant13311733peccant
pedant9319493pe_dant
pendant10314853pendant
pennant9312493pennant
petulant1048793petulant
phalanx1945203phalanx
pheasant1347083pheasant
pieplant1268733pieplant
plant75437113__plant
pleasant1048323pleasant
preplant12712913preplant
reactant10311433reactant
readapt1039743readapt
reagent8716603reagent
realest73322433realest
realist73225383realist
reallot7312133reallot
reblent9614253reblent
reboant9315093reboant
recant83228683re_cant
regnant8312843regnant
regrant8317323regrant
reland75920433re_land
relaxant1545843relaxant
relent64431853re_lent
reliant7319243reliant
remnant9312643remnant
replan83215823replan_
replans92814943replans
replants102811243replants
reptant92817073reptant
saint55147073s_a_int
salaam8711013s_alaam
salad65321833s_ala_d
salads75316963s_alads
salal55425703s_ala_l
salals65120083s_alals
salami8313103s_alami
salary9515213s_alary
salient7419763s_alient
salina64221123s_alina
saline65132703s_aline
sallet63734543s_allet
salon55228553s_alon_
salons63823693s_alons
salt45758523s_al__t
saran53730303s_aran_
sarans64224433s_arans
satang75711563s_atang
savants1038653s_avants
scabland1344293scabland
scalade10359263scalade
scalado10276473scalado
scalage103110533scalage
scalar83612433scala_r
scalare93311833scalare
scalars93711903scalars
scalene9310773scalene
scaleni936883scaleni
scaling103519373scaling
scant79735073s__cant
seabag938473seaba_g
seabags1037483seabags
seaboot9512333seaboot
seacoast1047783seacoast
seacraft1346523seacraft
seafront1148023seafront
seagirt8310153seagirt
seal45654373seal___
sealable101512693sealable
sealed74328363seal_ed
sealer63928963seal_er
sealers74323553sealers
sealery104011053sealery
sealifts1135473sealifts
seals54839693seal__s
seamanly1345403seamanly
seamark1336723seamark
seamen84518563seamen_
seaming103222113seaming
seamount1047923seamount
seaplanes1148713seaplanes
seaport9315603seaport
searest73322023searest
searing83330923searing
season62714903season_
seasons72614233seasons
seat47575563se__a_t
seating84130683seating
seawall1046203seawall
seaward1148183seaward
seaware1049633seaware
seaway12309993seawa_y
seaways13307513seaways
secants93413893se_cants
sedan65620423se_dan_
sedans74816093se_dans
seeling83522003seeling
segment10312563segment
seitan62613233seitan_
seitans73312303seitans
seladang1043403seladang
selah8319613se_la_h
selahs9313213se_lahs
select82621173se_lect
selling83225833selling
sellout7313583sellout
sent46963013se___nt
sepaline10311343sepaline
sequent16410323sequent
sergeant9129403sergeant
serjeant1596473serjeant
serpent92916283serpent
serrano768463serrano
servants1138003servants
setenant849933setenant
setline7313923setline
sewan85921293se_wan_
sewans95215903se_wans
sextan13389643sextan_
sextans14349263sextans
sextants15287383sextants
shallot103614133shallot
shalt85534493shal__t
shaman113314283shaman_
shamans123610903shamans
shealing123415463shealing
shetland1244633shetland
siamang1045333siamang
sibilant10158273sibilant
silane62718053s_ilane
silent64125843s_ilent
simulant1048083simulant
sklent103614353s_klent
slang66324023s__lang
slank95822773s__lank
slants64819083s__lants
slanty95114843s__lanty
slat46959023s__la_t
smalt74729333smal__t
solan55328153s_olan_
soland75115043s_oland
solano65314183s_olano
solans64122493s_olans
sonant6621953s_onant
spirant9814293spirant
splat76129343s_pla_t
splent84720193s_plent
splint85223283s_plint
stagnant946893stagnant
stalag7310023stala_g
stalags838643stalags
stalest73720173stalest
staling83925423staling
stalwart1147193stalwart
stealage946583stealage
stealing93416603stealing
sterilant947283sterilant
sunland837473sunland
supplant1247823supplant
talent6323323_talent
teacart91113193teacart
tenant6322473te_nant
ululant747693ululant
vacant11415133_vacant
valiant10314623_valiant
vealing114217423vealing
verdant11313293verdant
versant10313833versant
volant9316323_volant
weasand1135503weasand
weazand2043613weazand
wetland1135353wetland
yealing112716383yealing
zealot15313473zeal_ot

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272547.20318607.1
3Display Results2542540.0932731.2
 (SQL Overall)1786912547.70223200.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.