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

84 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
ferritic134707(None) 
ferritin1147381ferritin
erratic9311122_erratic
febrific1842712febrific
felsitic1345032felsitic
ferric1139992ferr__ic
ferrite103312752ferrit_e
ferrites112312832ferrites
ferritins1247272ferritins
hermitic1539652hermitic
neritic91314332ne_ritic
neuritic1048592neuritic
perlitic12310582perlitic
termitic1249282termitic
terrific1344802terrific
aerolitic1149343aerolitic
bornitic1246473bornitic
carditic1348713carditic
cerotic11415063ce_rotic
critic103616813__critic
dendritic1344803dendritic
dioritic1149493dioritic
eremitic1248553_eremitic
ergotic1049723_ergotic
eristic9814093_eristic
erotic82620273_e_rotic
erratics1046983_erratics
eucritic1247133eucritic
ferities111416723fe_rities
ferity122813343fe_rit_y
fermionic1643513fermionic
ferrate103014043ferrat_e
ferrates113013423ferrates
ferret93021173ferret__
ferreted1236333ferreted
ferreter1136543ferreter
ferreting13127703ferreting
ferrets103111393ferret_s
ferrety13287013ferret_y
ferriage1245463ferriage
ferried113411533ferri_ed
ferries103521083ferri_es
fibrotic1545733fibrotic
floristic1447163floristic
forrit91916623forrit__
frantic12310373f_rantic
frenetic1346293frenetic
gerontic1147963gerontic
heretic12314833he_retic
hermetic15310243hermetic
herpetic1547773herpetic
heuristic1445983heuristic
horrific1643623horrific
iritic83213823__iritic
jesuitic1743383jesuitic
leprotic1248583leprotic
leucitic1245233leucitic
marlitic1238343marlitic
mephitic1747143mephitic
meristic12311253meristic
metritis1049193metritis
necrotic12310053necrotic
nephritic1645903nephritic
neuritics1146233neuritics
neuritis848493neuritis
neurotic1039703neurotic
noritic91213543_noritic
pearlitic1345523pearlitic
pelitic111814653pe_litic
periotic12313443periotic
periti8319953pe_riti_
picritic1448263picritic
pleuritic1344553pleuritic
pruritic1267403pruritic
pyritic143311313_pyritic
soritic91414433_soritic
tektitic1444133tektitic
tephritic1645303tephritic
territ63421383territ__
territs72714503territ_s
veridic1338143ve_ridic
veristic1339883veristic
xerotic16410863xe_rotic
zeolitic1947463zeolitic

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.486367677.0
2DLD Change Limit146162847.75018859.6
3Display Results84840.0302800.0
 (SQL Overall)178691848.26621617.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.