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

191 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
statant731312(None) 
blatant9310672blatant
natant6318732_natant
saltant7316772saltant
satang75711562s_atang
savant9416042s_avant
sealant73118302sealant
seawant103613412seawant
sextant142911962sextant
stagnant946892stagnant
statal61613222stata_l
statin63921472statin_
stating83725162stating
statins73719772statins
statist7317722statist
adamant101110443adamant
alant55742293__alant
astatine8313533astatine
ataman81013063ataman_
atamans9710433atamans
attaint7313473attaint
attent62818323at_tent
avant86224663__avant
clamant11312433clamant
dilatant948203dilatant
distant83519953distant
emanant9411093emanant
estating92614993estating
etatist7415033etatist
etchant1249823etchant
extant132714753_extant
instant7815353instant
iterant7317783iterant
latent64124303_latent
mutant8317693_mutant
nutant6316383_nutant
octant81216553_octant
oscitant1046903oscitant
patent84524923_patent
peasant9314923peasant
platan83913693platan_
platane93112303platane
platans93413123platans
ratan53722663_ratan_
ratans63819373_ratans
ratany93411873_ratany
ratatat7412263ratata_t
rattan63613603rattan_
rattans73411953rattans
reactant10311433reactant
reptant92817073reptant
rhatany1353693rhatany
saint55147073s_a_int
saran53730303s_aran_
sarans64224433s_arans
satangs8479713s_atangs
satanic939933s_atanic
satanist8313373s_atanist
satara6315533s_atara
satay84718463s_ata_y
satays94411683s_atays
satin55935223s_atin_
satinet7325283s_atinet
sating74735453s_ating
satins64930483s_atins
satiny93817983s_atiny
saturant8410643saturant
savants1038653s_avants
scant79735073s__cant
scatt76030093scat__t
sealants82610743sealants
seaman84015903seaman_
seating84130683seating
seawan94111223seawan_
seawans10379943seawans
seawants11337973seawants
secant84023293s_ecant
seitan62613233seitan_
seitans73312303seitans
sejant133114483s_ejant
sejeant1489723sejeant
servant10313633servant
setenant849933setenant
sextan13389643sextan_
sextans14349263sextans
sextants15287383sextants
shaitan1036893shaitan_
shaitans1136413shaitans
shaman113314283shaman_
shamans123610903shamans
siamang1045333siamang
skating123613853skating
slant55238703s__lant
slating83724653slating
sonant6621953s_onant
soutane7312063soutane
spartan948333spartan_
spirant9814293spirant
staggart1046643staggart
staging93818373staging
stagnate947243stagnate
stain55727943sta_in_
stains64923653sta_ins
staking123919803staking
stalag7310023stala_g
stalags838643stalags
stalest73720173stalest
staling83925423staling
stalwart1147193stalwart
stamen84115943stamen_
stamens93411483stamens
stamina9310793stamina
stand65923283s__tand
stane55933003s__tane
stang66424683s__tang
stanine73417073stanine
staning83922243staning
stank95823303s__tank
staring84527053staring
starlet71620123starlet
starlit71512913starlit
start55642313s__tart
starting93116173starting
stat47352693s__ta_t
statable10310703statable
state56237333stat__e
stated75427833stat_ed
stately10310223stately
statement1148793statement
stater64427563stat_er
staters73922343staters
states64337083stat_es
static83118683stat_ic
statice92614033statice
statics93314533statics
station72717243station
stations82415223stations
statism9412283statism
statists8310163statists
stative102612933stative
stator64015483stat_or
stators73915583stators
stats55933363stat__s
statuary1144033statuary
statue66015323stat_ue
statued8459893statued
statues74614903statues
stature74410683stature
status65515213stat_us
statusy10455423statusy
statute7419323statute
staving113915703staving
staying114017323staying
stent55634513s__tent
stint57037663s__tint
stoat57135953st_oa_t
stotin63215063stotin_
stotins73213873stotins
stott56929793stot__t
strait64025893st_rait
strand74514823st_rand
strang75718313st_rang
strata63616283strata__
stratal72710603strata_l
stratas73013583strata_s
strunt64918913st_runt
student848343student
stunt55328173s__tunt
sultan63012593sultan_
sultana7257803sultana
sultans72411833sultans
suntan62613003suntan_
suntans72111733suntans
taggant9310223_taggant
taint55542283_ta_int
talent6323323_talent
tartan64217513_tartan_
tartana73010193_tartana
tartans72615823_tartans
tatami839193_tatami
tatar56122063_tata_r
tatars64619793_tatars
taunt55532283_ta_unt
tenant6322473_tenant
tetany959843_tetany
titan53318173_titan_
titans63414913_titans
titrant7315193_titrant
truant6315783_truant
tyrant9315333_tyrant
vacant11415133_vacant

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 Limit1340271916.37321030.4
3Display Results1911910.0633031.7
 (SQL Overall)1786911916.84226116.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.