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

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

30 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
listeriosis115303(None) 
listerioses1153751listerioses
listerias959233listeri__as
asterisks1346814_asteri_sks
asterisms11511064_asteri_sms
heterosis1258814_heter_osis
hipsterisms1852714hipsteri_sms
histrionic15112914hist_rionic
histrionics1692204hist_rionics
hysteresis1653444hyster_esis
interionic1248254_interionic
interiorise1148094_interiorise
interiors9513564_interio_rs
interposes12410564_interposes
listeria839434lister___ia
listers74026534lister____s
lithiasis1243594li_t_hiasis
lusterless1043694lusterles_s
mysterious1543904mysterio_us
osteosis846744_oste__osis
pityriasis1552254pi_tyriasis
postcrisis1454904postcri_sis
posteriors1256814posterio_rs
semiosis1059874__s_emiosis
siderosis1045544si_der_osis
sisterhoods15102774sisterhoods
stenosis847994__ste_nosis
stereopsis1263444__stereopsis
vibriosis1443924vi__briosis
wisterias1248104wisteri__as

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 Filter1786911488190.420425454.8
2DLD Change Limit148819308.98616561.2
3Display Results30300.0161875.0
 (SQL Overall)178691309.42218965.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.