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

183 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
abiotic1151046(None) 
biotic103816611_biotic
abiosis939372abiosis
acidotic1355982acidotic
acrotic112515542acrotic
albinotic1343632albinotic
albitic1139132albi_tic
amitotic1247002amitotic
amniotic1246402amniotic
anabiotic1345552anabiotic
anionic9312872anionic
aphotic142913122aphotic
aprotic112715242aprotic
argotic10310282argotic
aviatic1239242aviatic
avionic1237692avionic
azotic172711632a_zotic
bionic103614572_bionic
biontic1148332_biontic
biopic123710672_biopic
bioptic1337562_bioptic
biotics113812172_biotics
biotin83215832_biotin
idiotic1037462idiotic
meiotic11410932meiotic
miotic103715752_miotic
rabietic1245502rabietic
abatis84317933ab_atis
abattis9297823abattis
abbot9318453abbot__
abbotcy1642093abbotcy
abbots1039283abbot_s
abigail1044193abigail
ability12311443ability
abiogenic1446083abiogenic
abioses9311493abioses
aboil72217543ab_o_il
aboulic1156283aboulic
abrosia939273abrosia
abulic106411423ab_ulic
acetic10314503a_cetic
acidic113612133aci_dic
acinic104713543aci_nic
acmatic13311693acmatic
acronic112814693acronic
acrostic1239943acrostic
adipic1137263adi_pic
aeonic83517043a_eonic
aerobic11310213aerobic
agnatic10310973agnatic
agnostic1146713agnostic
agonic93515143a_gonic
aioli5318313a_ioli_
aiolis6316843a_iolis
akinetic1455953akinetic
albinic1136853albi_nic
aloetic9313183aloetic
amidic114012873ami_dic
aminic104413513ami_nic
ammonic1349163ammonic
amnionic1245603amnionic
anisic8313793ani_sic
anodic92813133a_nodic
anomic102516303a_nomic
anoxic152610673a_noxic
antibiotic1456623antibiotic
antic75728863a__ntic
aoristic10311163aoristic
aortic8316613a_ortic
aphetic142912853aphetic
aphonic142713393aphonic
aplitic11311743aplitic
apnoeic1147613apnoeic
aquatic1838113aquatic
arctic10313513a_rctic
ariosi64313033ariosi_
arkosic1346063arkosic
artistic10310893artistic
asbestic1245383asbestic
ascetic11310063ascetic
ascitic1139323ascitic
aseptic1137373aseptic
astatic9514193astatic
atactic11410083atactic
atomic104115603a_tomic
atonic83420473a_tonic
atopic103514143a_topic
atretic9313923atretic
attic75618353a__ttic
augitic1038283augitic
autistic10310103autistic
auxetic1637143auxetic
avionics1344953avionics
axiomatic2046993axiomatic
axonic154312723a_xonic
azoic162912063a_zo_ic
azonic175513153a_zonic
barytic1437823barytic
bibliotic1544243bibliotic
bioethic1544693_bioethic
biolytic1546773_biolytic
bionics114310873_bionics
biopics13318543_biopics
biopsic1345523_biopsic
biota74516823_biot_a
biotas84313923_biotas
biotech14104493_biotech
biotical1248863_biotical
biotins93114453_biotins
biotite9311033_biotite
biotitic1247573_biotitic
biotypic1744403_biotypic
bootie85421163_bootie
boric98024223_b_oric
bromic122412693_bromic
bustic101012693_bustic
cationic12310013cationic
cerotic11415063cerotic
chaotic14310043chaotic
clitic103315053cli_tic
critic103616813cri_tic
cubistic1445703cubistic
deictic1237703deictic
deistic10311173deistic
demotic12412343demotic
ekistic1377843ekistic
epidotic1346883epidotic
ergotic1049723ergotic
eristic9814093eristic
erotic82620273_erotic
exotic153112653_exotic
fibrotic1545723fibrotic
fistic11812573_fistic
ictic9311803__ictic
iodic84816753__iodic
ionic74622663__ionic
iritic83213823iri_tic
jaditic1746703jadi_tic
kenotic1359713kenotic
ketotic1348643ketotic
litotic939243litotic
lotic76420673__lotic
miotics112710653_miotics
mitotic1139713mitotic
mycotic1647713mycotic
myotic133112313_myotic
narcotic1277913narcotic
nepotic11310563nepotic
niobic1037243_niobic
obconic1346353obconic
osmotic11127613osmotic
otic66624823___otic
otitic83112683oti_tic
papistic1448733papistic
parabiotic1645083parabiotic
parotic112518043parotic
patriotic13107583patriotic
periotic12313443periotic
phimotic1747153phimotic
photic133316443_photic
pionic103515953_pionic
prebiotic1545413prebiotic
probiotic1546663probiotic
psilotic1245773psilotic
ptotic102713373_ptotic
quintic18308883quintic
quixotic2642943quixotic
rhotic112711233_rhotic
robotic1139223robotic
sabbatic1445323sabbatic
sadistic1148373sadistic
scabietic1542903scabietic
sciatic11910173sciatic
semiotic12710633semiotic
symbiotic1843803symbiotic
tabetic1138463tab_etic
taxitic1637093taxi_tic
thiolic1247323thiolic
thionic1238893thionic
viatic11311453_viatic
xerotic16410863xerotic
zygotic2254663zygotic
zymotic2345713zymotic

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.436409841.7
2DLD Change Limit1340271837.08018930.4
3Display Results1831830.0632904.8
 (SQL Overall)1786911837.57923577.1
 
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.