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 “termitic” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
termitic124928(None) 
hermitic1539651hermitic
eremitic1248542_eremitic
ferritic1347072ferritic
hermetic15310242hermetic
neritic91314332ner_itic
perlitic12310582perlitic
tektitic1444132tektitic
termini93410812termini_
termite9313892termit_e
termites10313692termites
terrific1344802terrific
aerolitic1149343aerolitic
bornitic1246473bornitic
carditic1348703carditic
cerotic11415063cer_otic
critic103616813_cr_itic
demotic12412343de_motic
dermic114511913derm__ic
emetic10614453_e_metic
ergotic1049723_ergotic
eristic9814093_eristic
erotic82620273_er_otic
erratic9311113_erratic
felsitic1345033felsitic
fermionic1643513fermionic
ferritin1147383ferritin
germanic1367503germanic
gerontic1147963gerontic
hematic141816743he_matic
heretic12314833her_etic
hermit11519443hermit__
hermitism1646143hermitism
hermitry1644453hermitry
hermits12312143hermit_s
herpetic1547773herpetic
iritic83213823_ir_itic
jesuitic1743383jesuitic
lateritic1147883later_itic
leucitic1245233leucitic
marlitic1238343marlitic
mephitic1747143mephitic
meristic12311253meristic
nematic111713993ne_matic
neumatic1258523neumatic
neuritic1048593neuritic
noritic91213543nor_itic
pearlitic1345523pearlitic
pelitic111814653pe_litic
periotic12313443periotic
periti8319953per_iti_
permit10321683permit__
permits11314003permit_s
pyritic143311313pyr_itic
sematic111716873se_matic
semiotic12710633se_miotic
sermonic1248883sermonic
somitic111512633_somitic
soritic91414433sor_itic
spermatic1548713spermatic
steatitic1145383steatitic
stemmatic1546013stemmatic
taxitic1637093t_axitic
telestic10118953telestic
tephritic1645303tephritic
terbic10410963ter__bic
terebic1137983ter_ebic
tergite8311003tergit_e
tergites9310543tergites
terminal1039733terminal
terming104016003termi_ng
terminus1037393terminus
termitaria1254413termitaria
termitary1444193termitary
termtime1244773termtime
terpenic1247213terpenic
territ63421373territ__
territs72714503territ_s
thematic152011483thematic
thermic1439333therm__ic
thermionic1753493thermionic
thermit12312013thermit__
thermite1339033thermit_e
thermites1438043thermites
thermits1338513thermit_s
toreutic1045193toreutic
tremolitic1454093tremolitic
truistic1046903t_ruistic
tryptic1446003t_ryptic
turmeric1244643turmeric
veridic1338143ver_idic
veristic1339883veristic
xerotic16410863xer_otic
zeolitic1947463zeolitic

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 Filter1786911461620.406440125.6
2DLD Change Limit146162947.40619735.6
3Display Results94940.0303133.3
 (SQL Overall)178691947.84222786.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.