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

49 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
bibliolatries179186(None) 
bibliolatrous1761032bibliolatrous
bibliolater1562453bibliolat__er
bibliolaters1672103bibliolat_ers
bibliolatry1861823bibliolatr__y
bibliologies1753373bibliol_ogies
heliolatries1552543_heliolatries
bardolatries1551924b_ardolatries
bibliographies2463384bibliographies
bibliomanias1862424biblioma_nias
bibliopegies1962064biblio_pegies
bibliophilies2282204bibliophilies
bibliotics1653174biblio__t_ics
billionaires1472954billionair_es
iconolatries1452574_iconolatries
idolatries1143994_i__dolatries
allopatries1354335__allopatries
babbitries1343195babbi___tries
babbittries1451645babbi__ttries
balladries1345195b_al__ladries
bibliomania1762445biblioma_ni_a
bibliomaniac2062305biblioma_niac
bibliomaniacs2161885bibliomaniacs
bibliophiles2192805biblio_philes
bibliopoles1752075biblio__poles
bibliotherapies24101995bibliotherapies
bibliotic1544245biblio__t_i_c
bibliotist1453845biblio__t_ist
bibliotists1552865biblio__tists
bigotries1286445bi__go__tries
billionaire1372645billionair_e_
biometries1448935__b_iometries
bipolarizes2453835bi__pola_rizes
ciliolate1145975ci_liolat__e_
dictionaries1554785dictiona_ries
fibrillates1653145fibrillat__es
heliolatrous1561375_heliolatrous
idiopathies1752275_i_diopathies
inviolacies1652795_inviola_cies
kilolitres1442725ki_l_olitr_es
militaries1249445mi_li_ta_ries
milliaries1248245milli__a_ries
millionaires1472995millionair_es
missionaries1453625missiona_ries
sibilancies15113015sib_i_lancies
sibilates1148445sib_i_lat__es
visionaries1454255vi_siona_ries
zillionaires2182005zillionair_es
zoolatries1943675___zoolatries

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 Filter1786911247900.403443402.0
2DLD Change Limit124790498.23615151.8
3Display Results49490.0301633.3
 (SQL Overall)178691498.66920612.6
 
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.