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

144 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
albitic113913(None) 
albinic1136851albinic
abiotic11510462a_biotic
albinotic1343632albinotic
albite8313312albit_e
albites9313202albites
albitical1345292albitical
albizia1864092albizia
aloetic9313182aloetic
aplitic11311742aplitic
ascitic1139322ascitic
augitic1038282augitic
calcitic1148192calcitic
clitic103315052cl_itic
illitic939252illitic
abatis84317933a_batis
abulic106411423a_bulic
acetic10314503a_cetic
acidic113612133a_cidic
acinic104713543a_cinic
aclinic11188973aclinic
acmatic13311703acmatic
aconitic1239533aconitic
acrotic112515543acrotic
actinic111810553actinic
adipic1137263a_dipic
agnatic10310973agnatic
albata839333albat_a
albatas938373albatas
albeit8314343alb_eit
albinal937813albinal
albinism1276413albinism
albinistic1454013albinistic
albino839933albi_no
albinos937653albinos
albizias1973533albizias
albizzia1851233albizzia
albumin1145563albumin
alcaic1039983al_caic
alembic1354773alembic
alibi7514233al_ibi_
alibis8311073al_ibis
alit46155693al_it__
alkalic13146973alkalic
alkylic16174233alkylic
allelic9118173allelic
allicin949953allicin
allylic12155843allylic
aluminic1245773aluminic
ambit94223713ambit__
ambition1246563ambition
ambits103713413ambit_s
amidic114012873a_midic
aminic104413513a_minic
amniotic1246403amniotic
anabatic1247453anabatic
anabiotic1345553anabiotic
anisic8313793a_nisic
antic75728863a__ntic
aoristic10311163aoristic
aortic8316613a_ortic
aphetic142912853aphetic
aphotic142913123aphotic
aplastic1249243aplastic
aprotic112715243aprotic
aquatic1838113aquatic
arbiter939933arbiter
arctic10313513a_rctic
argotic10310283argotic
artistic10310893artistic
asbestic1245383asbestic
ascetic11310063ascetic
aseptic1137373aseptic
astatic9514193astatic
atactic11410083atactic
atretic9313923atretic
attic75618353a__ttic
autistic10310103autistic
auxetic1637143auxetic
auxinic1644713auxinic
aviatic1239243aviatic
azotic172711633a_zotic
balletic1248073balletic
ballistic1346613ballistic
bauxitic1943623bauxitic
biotic103816613__biotic
calcific1445023calcific
carditic1348713carditic
clastic113013963clastic
clinic104312793cl_inic
clitics11279973cl_itics
colitic112916193colitic
critic103616813_critic
cubistic1445703cubistic
cubiti10399083cubiti_
dalmatic1348693dalmatic
dunitic1048143dunitic
elastic93013393elastic
elliptic1254753elliptic
felsitic1345033felsitic
fluidic1344383fluidic
galactic13106553galactic
glottic1036653glottic
glyptic1544503glyptic
hebetic1438633hebetic
ileitis738063ileitis
iritic83213823_iritic
jaditic1746703jaditic
lactic10713493_lactic
lentic83515743_lentic
lithic1139493_l_ithic
lotic76420673_l_otic
luetic8310383_luetic
lytic104513033_l_ytic
mannitic1248013mannitic
marlitic1238343marlitic
mastitic1248263mastitic
neritic91314333neritic
noritic91213543noritic
oolitic92512883oolitic
ophitic1439213ophitic
otitic83112683_otitic
palmitin1248053palmitin
pelitic111814653pelitic
phlebitic1843683phlebitic
plastic112815063plastic
poditic122611583poditic
politic112918713politic
pyritic143311313pyritic
rabbinic1443123rabbinic
rabietic1245503rabietic
rachitic1547593rachitic
robotic1139223robotic
rubidic1264543rubidic
sabbatic1445323sabbatic
salvific1643293salvific
somitic111512633somitic
soritic91414433soritic
sulfitic1345263sulfitic
tabetic1138463tabetic
tallitim1065503tallitim
taxitic1637093taxitic
uralitic10158463ural_itic
uveitic1244683uveitic

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.420425454.8
2DLD Change Limit1340271446.89319443.9
3Display Results1441440.0761894.7
 (SQL Overall)1786911447.38924183.4
 
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.