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

169 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
anatase73894(None) 
anatases839791anatases
anabas8314082anabas_
anabases1038082anabases
analyse10208892analyse
anaphase1345462anaphase
antae56828292an_ta_e
antas55432032an_tas_
abacas104414723abacas_
abakas123911743abakas_
abase76023483__abase
abatable1238023abatable
abate76627843abat__e
abates85825033abates_
abatis84317933abatis_
abatises10311013abatises
abayas114011703abayas_
acetate92514753acetate
acetose938843acetose
adnate72913483adnat__e
agamas97413443agamas_
agapae9388043agapa_e
agarose838653agarose
agate66525143agat__e
agates76121333agates_
agatize1739833agatize
agitas7310593agitas_
agitate8312063agitate
agnate73314873agnat__e
agnates82813183agnates_
alate55340323alat__e
alates64833963alates_
albatas938373albatas_
amative12311733amative
amidase1036723amidase
amylase1237013amylase
anabasis1047363anabasis
anagoge9166643anagoge
analysed12166913analysed
analyser11166133analyser
analyses11149963analyses
analyst10189323analyst
analyte10158813analyte
analyze19167013analyze
ananke1038283ana_nke
anankes1138763anankes
anapaest1046023anapaest
anapest9311553anapest
anaphases1446523anaphases
anas46649863an__as_
anatomise11117353anatomise
anatomy1246233anatomy
anatto6139913anat_to
anattos7138453anattos
angas65827983an_gas_
animas84418723animas_
animate91617213animate
anise55129703an__ise
anlace82513923an_lace
anlage72514223an_lage
anlas55626933an_las_
anlases72514903an_lases
annas55824883an_nas_
annates72415423annates_
annotate877713annotate
anoas57226493an_oas_
ansae55720973an_sa_e
ansate64517863an_sate
anta46839583an_ta__
ante46538903an_t__e
antes56334323an_tes_
antis55033313an_tis_
antisex1439693an_tisex
antre55224523an_t_re
antres65021003an_tres
ants47243473an_t_s_
antsy85712793an_t_sy
anytime1246043anytime
anywise1345203anywise
aortae65115473aorta_e
aortas65417783aortas_
apanage1036803apanage
apatite9312963apatite
appease1137913appease
apyrase1236363apyrase
aromatase1145263aromatase
asanas6514113asanas_
avatar937523avata_r
avatars1036443avatars
azotise1637073azotise
balatas9311833balatas_
bananas93312223bananas_
canalise10816213canalise
canastas1037693canastas_
cantatas103410083cantatas_
catalase1039213catalase
database1143533database
diabase1037113diabase
diastase946593diastase
elastase845643elastase
enate54428143enat__e
enates64026423enates_
encase83714363en_case
enchase1239453enchase
enolase7310193enolase
entases72816273en_tases
fantasie11117743fan_tasie
fantasm1236593fan_tasm
fantast10311703fan_tast
fantasy1336153fan_tasy
gnats65217713gnat_s_
guanase836213guanase
incase83615283in_case
inphase1245383inphase
instate71616473instate
intake10510863in_take
inulase739413inulase
jnanas13207303jnanas_
kanakas10327213kanakas_
katas95922093_katas_
lactase937953lactase
lanate6421263lanat__e
maltase938903maltase
mananas93414733mananas_
manatee9317663manat_ee
manatees10310423manatees
manats84623463manat_s_
mantas85725363man_tas_
mutase82811983_mutase
nadas66320813_nadas_
nalas55528363_nalas_
nanas55928633_nanas_
napas75924353_napas_
natal53921493_nata_l
natant6318733_natant
nates55238333_nates_
native9613013_native
nature6311263_nature
notate63217863_notate
nutate63017373_nutate
nutcase975763_nutcase
onstage838363onstage
panadas103312213panadas_
panamas113112753panamas_
pectase112410363pectase
pinatas93711483pinatas_
platane93112303platane
qanats154112813qanat_s_
reatas64021013reatas_
riatas63915083riatas_
sanative11310473sanative
sanitate8612043sanitate
sanitise81511813sanitise
snathe94415113snat_he
snathes104816493snathes
snaths95112913snaths_
sonatas7510293sonatas_
unawake1445343unawake
unaware1038033unaware
uncase83817433un_case
unease63816643un_ease
unitage838993unitage
unstate71916213unstate
untame82513603un_tame
vanadate1245513vanadate
vantage11109893van_tage
wantage11119623wan_tage
watape11208483_watape
zananas16319563zananas_

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.1401276364.3
2DLD Change Limit1340271697.14318763.4
3Display Results1691690.0602816.7
 (SQL Overall)1786911697.34324334.9
 
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.