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

47 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
osteitic104694(None) 
osteitis847011osteitis
otitic83112682o_t_itic
asbestic1245383asbestic
ascetic11310063asce_tic
ascitic1139323as_citic
aseptic1137373as_eptic
astatic9514193ast_atic
austenitic1252823austenitic
cosmetic1447783cosme_tic
cysteinic1643403cysteinic
esthetic13119773esthetic
eutectic1245503eutectic
gastritic1245323gastritic
lateritic1147883lateritic
mastitic1248263mast_itic
obstetric1342973obstetric
oneiric945613o_neiric
oolitic92512883o_olitic
ophitic1439213o_phitic
orchitic1546293orchitic
orectic1138823o_rectic
orthotic1348213orthotic
osmatic11179993os_matic
osmotic11127613os_motic
ossific1243103os_sific
osteitides1143963osteitides
osteoid848193oste_oid
osteosis846743osteosis
otitis63612343o_t_itis
postexilic2152333postexilic
sceptic1337833_sceptic
septic102713193_s_eptic
skeptic1545203_skeptic
smectic1336613_smectic
somitic111512633_somitic
soritic91414433_soritic
static83118683_st_atic
stearic939423_stearic
steatitic1145383_steatitic
stelic8313083_ste_lic
stenotic1048083_stenotic
steric8317063_ste_ric
stylitic1356343_stylitic
styptic1445453_styptic
syenitic1346743_syenitic
uveitic1244683_uveitic

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.420425454.8
2DLD Change Limit146162476.97020970.2
3Display Results47470.0301566.7
 (SQL Overall)178691477.42024082.3
 
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.