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

285 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
unstates8131499(None) 
instates81615821instates
unstate71916211unstate_
unstated91615811unstated
upstates10189641upstates
estates74520172_estates
gestates93213722gestates
instate71616472instate_
instated91613332instated
notates72817482_notates
nutates73214972_nutates
outstates91710752outstates
restates83423412restates
states64337082__states
substates111410312substates
testates83615442testates
tungstates1142672tungstates
uncrates10314552uncrates
unitages938272unitages
unsated83419932uns_ated
unseated91317682unseated
unseats73012852unseat_s
unstacks1446042unstacks
unstayed12168392unstayed
unswathes1544212unswathes
upstages11147372upstages
upstares10178582upstares
upstate91610492upstate_
upstater10156662upstater
upstaters11174792upstaters
acetates102013063acetates
agitates9310873agitates
anatases839793anatases
animates101316423animates
annates72415423an_nates
annotates977293annotates
ansate64517863ans_ate_
ansated84214003ans_ated
apostates1149163apostates
bistate9313813bistate_
bunkmates1743673bunkmates
caseates10313703caseates
castrates11312663castrates
costate94019273costate_
dictates11311373dictates
disrates91118143disrates
distastes1039623distastes
distaves12311393distaves
downstates1444343downstates
enates64026423en__ates
enslaves1136393enslaves
ensnares856893ensnares
enstatites1044523enstatites
enswathes1543433enswathes
entases72816273en_tases
estate64719763_estate_
estated83715573_estated
gestate83614073gestate_
gestated102910573gestated
hastate10313913hastate_
hesitates1269793hesitates
hostages122311693hostages
imitates10310503imitates
inflates11512193inflates
ingates82716893in_gates
ingrates9514153ingrates
initiates9411183initiates
inmates92715763in_mates
inscapes1237813inscapes
insnares858083insnares
insolates9311273insolates
installs858923installs
instals7611713insta_ls
instances1148743instances
instanter946243instanter
instants8910153instants
instars7411113insta_rs
instigates1148423instigates
insulates9311843insulates
inswathes1543953inswathes
intakes11310943in_takes
intestates10159423intestates
lactates10311223lactates
lunettes836753lunet_tes
lustrates939453lustrates
lysates10317473lys_ates
metates92720003_metates
ministates1246743ministates
misdates111113623misdates
mismates121114553mismates
misrates101318233misrates
misstates11710623misstates
mistakes141213403mistakes
mutates92215793_mutates
nates55238333_n__ates
negates83215833_negates
nictates1039583nictates
nidates8311883_nidates
nitrates82516203_nitrates
notate63217863_notate_
notated82713663_notated
nutate63017373_nutate_
nutated83113423_nutated
onstage838363onstage_
outskates13177153outskates
outstares91610183outstares
outstate81411993outstate_
outstated10169813outstated
pectates122213933pectates
postages112815323postages
postdates1248853postdates
prostates11314423prostates
pulsates1048813puls_ates
punctate1246473punctate_
punctated1445053punctated
punctuates1443453punctuates
reinstates1048283reinstates
reslates83619493reslates
restages92815763restages
restate73824873restate_
restated93120173restated
rotates72819773_rotates
runagates1044333runagates
sanitates9611733sanitates
sates54949323__s_ates
sensates8511133sens_ates
skates104219393__skates
slates64934063__slates
spates85028173__spates
stactes91914633__stactes
stades74626243__stades
stages75629493__stages
stakes103927293__stakes
stales65538293__stales
stanes64933403__stanes
stapes85028733__stapes
stares66038753__stares
stases64225563__stases
state56237333__state_
stated75427833__stated
stater64427553__stater
staters73922323__staters
stats55933363__stat_s
statues74614903__statues
status65515213__status
staves94525193__staves
substages12127353substages
substate101711083substate_
substrates12168543substrates
sunshades1344153sunshades
sunstones947873sunstones
tates55444983___tates
testate73916233testate_
tungstate1042863tungstate_
tungstites1152253tungstites
tunicates11268743tunicates
uintaites9136333uintaites
ululates848433ululates
unabated11310133unabated
unakites1237543unakites
unawares1137053unawares
unbales92914863un_bales
unbated103317733un_bated
unbeaten1038013unbeaten
unbraces12229413unbraces
unbrakes14258413unbrakes
uncages103213773un_cages
uncakes133012743un_cakes
uncases93516553un_cases
uncoated11314963uncoated
uncrate9415953uncrate_
uncrated11416313uncrated
uncreates11310433uncreates
undated93118463un_dated
understates1247703understates
undrapes1138603undrapes
undulates1048923undulates
uneases73316263un_eases
uneaten7412543un_eaten
ungated92717213un_gated
ungulates1048343ungulates
unhats91110623un_hat_s
unhatted1238183unhatted
unheated121514553unheated
unifaces1346393unifaces
unitage838993unitage_
unitards945623unitards
unites65024853un__ites
unities72520143unit_ies
unitizes1739133unitizes
unlaces92513623un_laces
unlades82612833un_lades
unmakes132810793un_makes
unmated103317023un_mated
unmatted1138293unmatted
unquotes1745353unquotes
unrated82621553un_rated
unsafe9310693uns_afe_
unsalted9510923unsalted
unsaturates1154593unsaturates
unsaved113312193uns_aved
unsawed112911503uns_awed
unsays9399543uns_a_ys
unscaled111410113unscaled
unscathed1535313unscathed
unsealed91513623unsealed
unseals73212573unsea_ls
unseamed111210663unseamed
unseams9338913unsea_ms
unseared91113943unseared
unseat64221023unseat__
unsets64116163uns_et_s
unsettles964653unsettles
unsexes14248923uns_exes
unshaded13149263unshaded
unshaken15175403unshaken
unshamed14148053unshamed
unshaped14148443unshaped
unshapen13155443unshapen
unshared121510703unshared
unshaved15157733unshaved
unshaven14154883unshaven
unsheathes16183843unsheathes
unsifted12128773unsifted
unslaked1338463unslaked
unsnags835463unsna_gs
unsnaps935423unsna_ps
unsnarls894883unsnarls
unsoaked1338853unsoaked
unsorted9312513unsorted
unstable10313763unstable
unstabler1145623unstabler
unstablest1244183unstablest
unstably1339493unstably
unstack1337373unsta_ck
unstacked1636433unstacked
unstained1038673unstained
unstalked1435523unstalked
unstamped1454603unstamped
unstarred1036363unstarred
unstating10711213unstating
unsteadies1154153unsteadies
unsteel738793unst_eel
unsteels845793unsteels
unstep839223uns__tep
unsteps936213unst_eps
unsticks1436233unsticks
unstinted1038553unstinted
unstitch1343593unstitch
unstitches1543563unstitches
unstoned9311043unstoned
unstops936983unst_ops
unstraps1045983unstraps
unstress837373unstress
unsuited9310783unsuited
unswathe1444603unswathe
unswathed1634543unswathed
unswayed15155713unswayed
untacks1357503un_tacks
untaken1137643un_taken
untame82513603un_tame_
untamed102913223un_tamed
untasted92011573un_tasted
untaxed152710583un_taxed
unties64326923un_t_ies
untunes72211253un_tunes
unweaves1436143unweaves
updates10329793u_pdates
uprates93814863u_prates
upscales12155993upscales
upstage10167443upstage_
upstaged12135243upstaged
upstager11164633upstager
upstagers12173333upstagers
upstairs1043643upstairs
upstands1144093upstands
upstare9158683upstare_
upstared11156573upstared
upstarted1244213upstarted
upstarts10165273upstarts
uptakes1336593u_ptakes
urates65027763u__rates
urinates8314133urinates
usages759603u_s_ages
wastages12109753wastages

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622858.54617103.0
3Display Results2852850.1561826.9
 (SQL Overall)1786912858.85820172.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.