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

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

32 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
hemichordates246163(None) 
hemichordate2361811hemichordate_
hemihydrates2461513hemi_hydrates
chordates1547684____chordates
hemihydrate2361654hemi_hydrate_
hemihydrated2561204hemi_hydrated
urochordates1862114_urochordates
bichromates2054695__bichromates
camphorates20124765cam_phor_ates
chordate1448035____chordate_
decorates12314745de__c_or_ates
dichromates1956075__dichromates
electorates1347465_elector_ates
emigrates1248585_emi__gr_ates
emirates101214855_emi___r_ates
ephorates1459165_e__phor_ates
erythorbates2082075_erythorbates
excoriates1946325_e_xc_oriates
hemochromatoses2771285hemochromatoses
hermaphrodites257985hermaphrodites
hexachords2652195hexachord___s
hexahydrates2961635he_xahydrates
meliorates1288905meli__or_ates
microstates1547445__microstates
micturates1456095__mictur_ates
mithridates1752845__mithridates
perchlorates1953385pe_rchlor_ates
periodates1347865peri__o_dates
rectorates12410365re__ctor_ates
redecorates1465685redec_or_ates
remigrates1348585remi__gr_ates
urochordate1752145_urochordate_

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit124790329.29613424.1
3Display Results32320.0162000.0
 (SQL Overall)178691329.70218418.0
 
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.