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

439 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
insane631489(None) 
inane52820341in_ane
insaner7310441insaner
ansae55720972ansa_e
ansate64517862ansate
immane1038882immane
inaner62213542in_aner
inanes62519802in_anes
incage93513622incage
incant82418512incant
incase83615282incase
indene73215372indene
infant92315132infant
infante101910882infante
infare9313082infare
ingate73018242ingate
inhale9411512inhale
inlace82513042inlace
inland7310312inland
inmate82917362inmate
innage73011572innage
innate63917312innate
inosine7314282inosine
insanely1146122insanely
insanest8410342insanest
inscape1138022inscape
inside7613452inside
insigne837672insigne
insnare748242insnare
insole63515862insole
inspan837512inspan_
inspans937802inspans
instance1049882instance
instant7815352instant
instate71616482instate
insure63416602insure
intake10510862intake
intine61021982intine
intone61115432intone
invade10157852invade
lindane839032lindane
linsang835862linsang
sane45954342__sane
sinsyne1043302sinsyne
tisane6311572tisane
unsafe9310692unsafe
alane56135613_alane
alkane104313323alkane
ananke1038283an_anke
ancone83916953ancone
andante8311273andante
ane37866953___ane
anlace82513923anlace
anlage72514233anlage
ansa45927773ansa__
ansated84214003ansated
antae56828293anta_e
anyone94612733anyone
arcane81216743arcane
arsine64021043arsine
asana5315483_asana
bane65250433__bane
binate8419773bin_ate
biplane1139033biplane
borane84620213borane
butane8313653butane
cane66653123__cane
cetane8315283cetane
cosine83823513cosine
crane75331603_crane
decane93818873decane
desand84812633desand
dioxane1565423dioxane
dissave1139413dissave
dosage82810003dosage
enate54428153en_ate
encage93713503encage
encase83714363encase
enface112510353enface
engage82812103engage
engine71114863engine
enhance1239693enhance
enlace82213233enlace
enplane939723enplane
enrage72715073enrage
ensile62616473ensile
enslave1036273enslave
ensnare767123ensnare
ensue54013833ens_ue
ensure63416003ensure
eosine64519413eosine
esne47018793_es_ne
ethane94613243ethane
fane75343573__fane
finale94116763fin_ale
finance1238573fin_ance
fissate103010033fissate
furane94015493furane
gane55145303__gane
ginseng933433ginseng
henbane1237353henbane
hexane16379533hexane
humane112812173humane
ideate7313683ideate
iguana735813iguana
image81411293i_mage
imine75821063i_mine
immune1035433immune
impale102811663impale
impanel1137093impanel
impone103011863impone
inanely1037943in_anely
inanest72115363in_anest
inapt73522693in_apt
inarm7314423in_arm
inbye10427063in_bye
incaged114010443incaged
incages103013883incages
incanted11259543incanted
incants92012803incants
incased103612393incased
incases93615973incases
incense92410303incense
incent83320723incent
incise83515333incise
incite83618733incite
incline9314643incline
income10712093income
incony1139083incony
incuse83513573incuse
indaba935633indaba
indamine1148433indamine
indenes82916253indenes
indent73021243indent
indie63721473in_die
indite73520323indite
indole74516053indole
induce93811533induce
indue63516673in_due
infall939403infall
infamy1435653infamy
infancy1546173infancy
infanta10237253infanta
infantes11249633infantes
infants102210773infants
infares10313023infares
infauna1044403infauna
infaunae1143773infaunae
inflame1256963inflame
inflate10312313inflate
infuse93110573infuse
ingates82716913ingates
ingenue847133ingenue
ingle64120433in_gle
ingrate8715123ingrate
inhaled1169333inhaled
inhaler1068053inhaler
inhales10511863inhales
inhaul936803inhaul
inhere9313713inhere
inhumane1364743inhumane
inhume1196583inhume
inia45024703inia__
inion54620183inion_
inions64417003inions
injure133410863injure
inking115119053inking
inkle94515833in_kle
inkstand1343803inkstand
inkstone1245413inkstone
inlaced10239873inlaced
inlaces92512903inlaces
inlaid7310143inlaid
inlander937223inlander
inlands838783inlands
inlay85214323inla_y
inlayer1036933inlayer
inlays9389873inlays
inmates92715783inmates
inn36727433in__n_
innages82911303innages
inned64118423in__ned
inner54920633in__ner
inning73617633inning
inns46920933in__ns
inosines8312703inosines
inosite7314063inosite
inphase1245383inphase
inrun52911373inrun_
inruns6359513inruns
ins35945603ins___
insanity1147333insanity
inscapes1237813inscapes
inseam8329993inseam
inseams9307903inseams
insect83916583insect
insert64325253insert
inset54430863ins_et
insets64016133insets
inshore1038723inshore
inshrine1147493inshrine
insider849733insider
insides8512653insides
insist6314513insist
insnared956123insnared
insnarer865303insnarer
insnares858083insnares
insolate8311893insolate
insoles73516243insoles
insoul638463insoul
inspanned1242853inspanned
inspire938253inspire
instable10313203instable
instal6712193instal
install779363install
instals7611713instals
instanced1245703instanced
instances1148753instances
instancy1346573instancy
instanter946243instanter
instants8910153instants
instar6310013instar
instars7411133instars
instated91613343instated
instates81615833instates
instep838193instep
instil61111383instil
insulant849883insulant
insulate8312843insulate
insult62813673insult
insurance1147453insurance
insurant8411433insurant
insured83714253insured
insurer73312803insurer
insures73117263insures
inswathe1443693inswathe
intact8314663intact
intakes11310943intakes
intend72310373intend
intense72511903intense
intent63122773intent
interne73218153interne
intime81014273intime
intines7921113intines
intoned8811993intoned
intoner7811673intoner
intones7816543intones
intranet8418443intranet
intrant7318753intrant
intwine1038513intwine
inulase739413inulase
inurbane1045253inurbane
inure54119053in_ure
inurn53712863inurn_
inurned8328053inurned
inurns63310983inurns
invaded12127043invaded
invader11146453invader
invades11118293invades
invar839513inva_r
invars9310003invars
invent93316363invent
invite93715033invite
invoke1336213invoke
inwall938343inwall
inward10310333inward
inweave1344723inweave
inwind10268413inwind
inwove12167273inwove
iodate7313503iodate
iodine74618653iodine
ionone6313443ionone
irade65618153i_rade
irate55627983i_rate
irone55126363i_rone
isatine7311763i_satine
island738533island
isle45121703i_s_le
issuance1045223issuance
issuant748263issuant
issue559213i_ssue
istle52214713i_stle
jane115031483__jane
jnana12159043jn_ana
kane85133973__kane
kinase104210653kin_ase
kinsman1335963kinsman_
kinsmen1335653kinsmen
knave12389463kn_ave
knawe12397883kn_awe
lane45153333__lane
lasagne844063lasagne
liane54720663_liane
linage7713403lin_age
lindanes939173lindanes
lineage878983lineage
lineate7815153lineate
linkage1295963linkage
linsangs944413linsangs
lysate9388103lysate
lysine94210553lysine
mane65052033__mane
mensae84114053mensa_e
mesne75116293mes_ne
minae75627723min_a_e
mintage101110123mintage
minyan1138173minyan_
minyans1237263minyans
misate81222693misate
misname11119483misname
montane91313623montane
mundane1038073mundane
naan47621933_naan_
naans55815253_naans
nabe66029493_n_abe
nae35952743_n_a_e
name65637413_n_ame
nan37854883_n_an_
nana46632903_n_ana
nance74721843_n_ance
nans46139403_n_ans
nape65230803_n_ape
nave75732313_n_ave
nene45932063_n_ene
nidate7313783nidate
nine45842173_n_ine
none45743173_n_one
nuance859043_nuance
octane81411633octane
online6315843online
onside7511803onside
onstage838363onstage
pane64950293__pane
pavane114113443pavane
pentane9415743pentane
pesade9311103pesade
pinang92611593pin_ang
pinbone1138183pinbone
pinene82915643pin_ene
pinnace113510313pinnace
pinnae84414643pinna_e
pinnate93613743pinnate
pintano998993pintano
pinwale1257843pinwale
pissant91012503pissant
plane74929143_plane
recane83022873recane
resale64025543resale
rinsable10310043rinsable
rinse54820973rins__e
rinsing82516113rinsing
rusine63916593rusine
sabe66140573__sabe
sade55544473__sade
sae38365183__sa_e
safe75930953__safe
sage55044593__sage
sake85244963__sake
sale44959703__sale
same65245643__same
sand55338473__sand
saned65636273__saned
saner54334323__saner
sanes55649073__sanes
sang55441233__sang
sank85236833__sank
sans45153363__sans
sate45556103__sate
save75741363__save
sene46848053__sene
sensate7311893sensate
sesame8311013sesame
silane62718053silane
sine46560623__sine
sinkage1287263sinkage
sinuate7412163sinuate
skeane104611373skeane
snake94821113sn_ake
snare54429983sn_are
sone46649983__sone
stane55933003_stane
syne75725763__syne
thane86122533_thane
tinman82411143tinman_
tinstone848173tinstone
tinware1038603tinware
tisanes7311853tisanes
tolane64316583tolane
tsade64311123_tsade
unbale83616403unbale
unban72114333unban_
unbans81912623unbans
uncage93014873uncage
uncake122813523uncake
uncase83817433uncase
undine7817263undine
undone7914253undone
unease63816643unease
unhand10410383unhand
unhang1038443unhang
unlace82215173unlace
unlade72714153unlade
unmade92911063unmade
unmake122811213unmake
unman72715423unman_
unmans82211993unmans
unsaid7411833unsaid
unsated83419933unsated
unsaved113312193unsaved
unsawed112911503unsawed
unsawn9317463unsawn
unsay83212843unsa_y
unsays9399543unsays
unseen62012623unseen
unsent63820963unsent
unsnag736393unsnag
unsnap836203unsnap
unstate71916213unstate
unsung736983unsung
unsunk1036333unsunk
unsure62815413unsure
untame82513603untame
untune62511603untune
urbane82211383urbane
ursae55214453ursa_e
ursine64114123ursine
usage6410213_usage
usance858013_usance
vane75534693__vane
vinasse1044513vinasse
vintage11128143vintage
visage1049083visage
wane76344723__wane
windage1237933windage
winsome1237463winsome
zincate1838533zincate
zingani1744813zingani
zingano1744203zingano
zingare1737143zingare

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 Filter1786911127160.390458182.1
2DLD Change Limit1127164395.73619650.6
3Display Results4394390.1532869.3
 (SQL Overall)1786914396.27928458.5
 
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.