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

51 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
histologies154663(None) 
hierologies1547062hierologies
histologic1654962histologi_c
histologist1547982histologist
histologists1646292histologists
misologies13139062mis_ologies
nostologies1246582nostologies
sitologies1148702si_tologies
astrologies1247913_astrologies
biologies12311183bi__ologies
cetologies13410843_cetologies
cosmologies1646703cosmologies
cytologies1639263_cytologies
fetologies1439173_fetologies
hagiologies1645343hagiologies
haplologies1744763haplologies
hematologies1847543hematologies
herbologies1746553herbologies
histological1846063histological
histology1645653histolog__y
histolyses1643393histol_yses
histolysis1653093histolysi_s
histories12412473hist__ories
homologies16311513h_omologies
horologies14411053h_orologies
hydrologies1948173hydrologies
hymnologies2046103hymnologies
hypnologies2046083hypnologies
ideologies1237333_ideologies
isologues1044563_is_ologues
limnologies1445533limnologies
lithologies1546833lithologies
missiologies1553313missiologies
mixologies20136583mi_xologies
museologies1444543museologies
nosologies1148103nos_ologies
oinologies1148303oi_nologies
ontologies1139883_ontologies
orismologies1553293orismologies
osteologies1247053_osteologies
otologies10311403__otologies
philologies1747203phi_lologies
physiologies2155363physiologies
phytologies2049043phytologies
posologies1349543pos_ologies
rhinologies1546503rhi_nologies
scatologies1446863scatologies
seismologies1543903seismologies
sinologies1148893si_nologies
tautologies1245913tautologies
virologies1447213vi_rologies

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 Filter1786911216330.233766914.2
2DLD Change Limit121633515.42022441.5
3Display Results51510.0331545.5
 (SQL Overall)178691515.68631426.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.