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

91 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
rachitis134835(None) 
rachitic1547591rachitic
orchitis1346422orchitis
pachisis15268822pachisis
rachets124516832rachet_s
rachides141511222rachides
rachis114017652rach__is
rachises131412412rachises
rachitides1644532rachitides
tracheitis1543922tracheitis
achiotes1339003_achiotes
acuities10312453_acuities
archils12510533archi_ls
archines133815253archines
archings14499863archings
archives16399553archives
archivist1745493archivist
arthritis1247473arthritis
brachets154311983brachet_s
brachials16206943brachials
brachiates1746353brachiates
bronchitis1753453bronchitis
cachets145014263cachet_s
canthitis1445273canthitis
carditis11310223carditis
chilis115517873__chilis
chitin113114963__chitin
chitins122713793__chitins
chits105424573__chit_s
dacites101114593dac_ites
dacoities1248213dacoities
dacoits1079073dacoit_s
dashikis1643673dashikis
fasciitis1443543fasciitis
fascitis1346013fascitis
gracilis11247033grac_ilis
graffitis1642713graffitis
graphites1546823graphites
graphitic1744793graphitic
kachinas1736343kachinas
machetes1539633machetes
machines15312893machines
machinist1648483machinist
mammitis1145593mammitis
mastitis1039103mastitis
mephitis1546113mephitis
orchitic1546293orchitic
pachisi14329523pachisi_
parchisis16318573parchisis
proctitis1348363proctitis
rabbits11299863rabbit_s
rachet115028973rachet__
racheted14149503racheted
racheting1537793racheting
rachial122012173rachi_al
rachilla1345713rachilla
racings105015133rac_ings
racisms112310813rac_isms
racists92613323rac_ists
rackets134916873racket_s
raitas64417673ra__itas
raphias123511083raphi_as
raphides14188393raphides
raphis114014323raph__is
rarities8316333ra_rities
ratchets133110263ratchet_s
ratites74920683ra_tites
raucities1148163raucities
rawhides15145543rawhides
recites93524583rec_ites
recits83621353rec_it_s
rhachides1853663rhachides
rhachis1555693rhach__is
rhachises1763973rhachises
rhinitis1145263rhinitis
rochets124213473rochet_s
ruchings14287073ruchings
sachets123914103sachet_s
sashimis1343753sashimis
tachinid1446243tachinid
tachinids1544043tachinids
tachisms1567143tachisms
tachistes1466043tachistes
tachists1348183tachists
tahinis1048013ta_hinis
trachytes1745923trachytes
trachytic1944183trachytic
trichites1448883trichites
vacuities1447143vacuities
wapitis1236473wa_pitis
yachts1437023yach_t_s

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.420425454.8
2DLD Change Limit146162917.78318779.6
3Display Results91910.0303033.3
 (SQL Overall)178691918.23321704.2
 
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.