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

313 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
instate7161648(None) 
instated91613341instated
instates81615831instates
unstate71916211unstate
ansate64517862ans_ate
bistate9313822bistate
costate94019272costate
estate64719762_estate
gestate83614072gestate
hastate10313912hastate
imitate9310872imitate
inflate10312312inflate
ingate73018242in_gate
ingrate8715122ingrate
initiate8412692initiate
inmate82917362in_mate
innate63917312in_nate
insane6314892ins_ane
insatiate948062insatiate
inscape1138022inscape
insnare748242insnare
insolate8311892insolate
instable10313202instable
instal6712192insta_l
install779362install
instals7611712instals
instance1049882instance
instant7815352instant
instanter946242instanter
instants8910152instants
instar6310012insta_r
instars7411132instars
instigate1048612instigate
insulate8312842insulate
inswathe1443692inswathe
intake10510862in_take
intestate9159872intestate
ministate1147262ministate
misstate10711342misstate
nictate9310222nictate
notate63217862_notate
nutate63017372_nutate
onstage838362onstage
reinstate948902reinstate
restate73824882restate
state56237332__state
testate73916232testate
unstated91615812unstated
unstates81314992unstates
upstate91610492upstate
acetate92514753acetate
agitate8312063agitate
anatase738943anatase
animate91617213animate
annotate877713annotate
ansae55720973ans_a_e
ansated84214003ans_ated
antae56828293an_ta_e
antistate9410143antistate
apostate1049853apostate
aristate8312133aristate
astute6310763_astute
binate8419773bin__ate
caseate9314783caseate
castrate10313863castrate
costae85319683costa_e
cristate10310603cristate
curtate9312643curtate
cuspate1138233cuspate
dentate8315153dentate
diastase946603diastase
dictate10311663dictate
digitate1098683digitate
dilatate947773dilatate
dinette8310013dinet_te
disrate81418523disrate
distaste939943distaste
downstate1344613downstate
enate54428153en__ate
enslave1036273enslave
ensnare767123ensnare
enstatite946193enstatite
enswathe1443153enswathe
estated83715573_estated
estates74520183_estates
fissate103010033fissate
fossate10388603fossate
gestated102910573gestated
gestates93213733gestates
guttate8328903guttate
hesitate1169973hesitate
hostage113111233hostage
ideate7313683i_deate
imamate1138103imamate
imitated1138263imitated
imitates10310503imitates
inane52820343in__ane
incage93513623in_cage
incase83615283in_case
inchoate1347673inchoate
incite83618733in_cite
increate10312203increate
incubate1238663incubate
incudate1138873incudate
indagate1047193indagate
indicate11313353indicate
indite73520323in_dite
indurate9311873indurate
indusiate1046403indusiate
infante101910883infante
infare9313083in_fare
infatuate1244773infatuate
inflame1256963inflame
inflated12410863inflated
inflater1149893inflater
inflates11512193inflates
infuscate1444333infuscate
ingates82716913in_gates
ingrates9514173ingrates
inhale9411513in_hale
initiated10510113initiated
initiates9411183initiates
inkstand1343803inkstand
inkstone1245413inkstone
inlace82513043in_lace
inmates92715783in_mates
innage73011573in_nage
innovate1145643innovate
inosite7314063inosite
inphase1245383inphase
insaner7310443ins_aner
inscapes1237813inscapes
inseam8329993insea_m
inseams9307903inseams
insect83916583insect_
insects93710843insects
insensate945393insensate
insert64325253insert_
inserted92413053inserted
inserter82312133inserter
inserts74013993inserts
inset54430863ins_et_
insets64016133ins_ets
insetted9249023insetted
insetter8218593insetter
insheath14114423insheath
insheathe15163883insheathe
inshore1038723inshore
inside7613453ins_ide
insigne837673insigne
insinuate945963insinuate
insist6314513insist_
insisted998673insisted
insister888783insister
insists739083insists
insnared956123insnared
insnarer865303insnarer
insnares858083insnares
insolated1039713insolated
insolates9311273insolates
insole63515863ins_ole
inspan837513inspa_n
inspans937803inspans
inspire938253inspire
installed1045853installed
installer945013installer
installs858923installs
instanced1245703instanced
instances1148753instances
instancy1346573instancy
instantly1256013instantly
instarred1043963instarred
instating10812213instating
instead836203instead
instep838193inst_ep
insteps936573insteps
instigated1247693instigated
instigates1148423instigates
instil61111383inst_il
instill789063instill
instils7811453instils
institute946443institute
instroke1245583instroke
insulated10310713insulated
insulates9311843insulates
insult62813673insult_
insulted937193insulted
insulter836883insulter
insults7268963insults
insure63416603ins_ure
inswathed1642963inswathed
inswathes1543953inswathes
intact8314663in_tact
intakes11310943in_takes
interstate10710973interstate
intestates10159433intestates
intimate101013833intimate
intime81014273in_time
intine61021983in_tine
intitle7610583in_title
intonate8310923intonate
intone61115433in_tone
intrastate1055713intrastate
intubate1047533intubate
inulase739413inulase
inundate946043inundate
inutile739883inutile
invade10157853in_vade
invite93715033in_vite
invocate1347833invocate
inweave1344723inweave
iodate7313503i_odate
irate55627983i__rate
irritate867873irritate
isolate7313923isolate
istle52214713i_st_le
iterate71119113iterate
lactate9312693lactate
lineate7815153lin_eate
lustrate8310443lustrate
lysate9388103lys_ate
metate82720533_metate
militate10311673militate
ministates1246743ministates
mintage101110123min_tage
misate81222693mis_ate
misdate101413963misdate
mismate111415353mismate
misrate91319143misrate
misstated1278973misstated
misstates11710633misstates
mistake131312623mistake
mutate83017483_mutate
negate72915573_negate
nictated1137793nictated
nictates1039593nictates
nidate7313783_nidate
niobate937703niobate
nitrate72017013nitrate
notated82713663_notated
notates72817483_notates
nutated83113423_nutated
nutates73214973_nutates
outate62923403_outate
outstate81411993outstate
pectate112214693pectate
peltate92013773peltate
pinnate93613743pin_nate
postage103214853postage
postdate1139653postdate
prostate10314533prostate
punctate1246473punctate
reinstated1147283reinstated
reinstates1048293reinstates
reslate73520593reslate
restage83316193restage
restated93120183restated
restates83423433restates
roseate7613453roseate
rostrate8313843rostrate
rotate63320343_rotate
sanitate8612043sanitate
sate45556103__s_ate
scutate9310323scutate
sensate7311893sens_ate
septate9511873septate
sinuate7412163sin_uate
skate94721553__skate
slate55438283__slate
spate74731583__spate
stacte82113913__stacte
stade64825303__stade
stage65330193__stage
stake95927533__stake
stale55637103__stale
stane55933003__stane
stare54440263__stare
stat47352693__stat_
stated75427833__stated
stater64427563__stater
states64337083__states
stats55933363__stats
statue66015323__statue
stave85324993__stave
substate101711093substate
tate44748603___tate
testae64216253testa_e
testates83615453testates
tinplate1047743tinplate
tinstone848173tinstone
tristate8311033tristate
tungstate1042873tungstate
uintaite8127353uin_taite
uncrate9415953uncrate
unitage838993unitage
unsafe9310693uns_afe
unsated83419933uns_ated
unseat64221023unseat_
unseated91317683unseated
unseats73012853unseats
unstable10313763unstable
unstack1337373unstack
unstayed12168393unstayed
unswathe1444603unswathe
untame82513603un_tame
upstage10167443upstage
upstare9158683upstare
upstater10156663upstater
upstates10189643upstates
vintage11128143vin_tage
vittate10409733vittate
wastage11109253wastage
zincate1838533zin_cate

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.563317390.8
2DLD Change Limit1340273137.12618808.2
3Display Results3133130.1402235.7
 (SQL Overall)1786913137.82922824.2
 
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.