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

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

44 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
kremlinologists22141391kremlinologists_
kremlinologist21141772kremlinologist__
kremlinologies2161493kremlinologi_es_
criminologists1952974crim_inologists_
criminologist1863645crim_inologist__
demonologists1755565_dem_onologists_
kremlinology2271165kremlinolog____y
selenologists1455335_se_lenologists_
semiologists1548225_sem_i_ologists_
campanologists2152626_campanologists_
criminologies1852956crim_inologi_es_
cryobiologists2254106cryobi_ologists_
demonologist1657056_dem_onologist__
dermatologists18134926derm_atologists_
embryologists2153126__embryologists_
enologists11310626__e___nologists_
ethnologists1647046__e_thnologists_
gemmologists1845236_gem__mologists_
gemologists1577886_gem___ologists_
hematologists19217056_hem_atologists_
immunologists18124496__immunologists_
iridologists1444686ir___idologists_
lexicologists2374156_le_xicologists_
limnologists1545326____limnologists_
mixologists2145686___m_ixologists_
monologists14410076___m_onologists_
nematologists16166606_nem_atologists_
oceanologists1654306oce__anologists_
palynologists1954996__palynologists_
penologists1449596_pe___nologists_
phrenologists1956296phre___nologists_
primatologists19184356prim_atologists_
pteridologists18133726pte_ridologists_
radiologists1497376_r_adi_ologists_
selenologist1357006_se_lenologist__
semiologist14410716_sem_i_ologist__
sinologists1257676____sinologists_
speleologists1654326spe_l_eologists_
technologists19125706_te_chnologists_
teleologists1347226_te_l_eologists_
terminologies1653446term_inologi_es_
tribologists1546166tr___ibologists_
urbanologists1653256ur__banologists_
vexillologists2591746_vexillologists_

Search took 6 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 Filter178691658740.310576422.6
2DLD Change Limit65874444.67314096.7
3Display Results44440.0301466.7
 (SQL Overall)178691445.01335645.5
 
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.