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

72 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
ichthyologists266231(None) 
ichthyologist2562781ichthyologist_
ichthyologies2552292ichthyologi_es
ichthyological2882453ichthyological
anthologists1648034_anth_ologists
cetologists1449164_cet__ologists
chronologists1966114_chronologists
cytologists1748014_cyt__ologists
ethnologists1647044__ethnologists
ethologists1549024__eth_ologists
ichthyology2652164ichthyolog___y
lichenologists2063034lich_enologists
mythologists2146894_myth_ologists
pathologists1848374_path_ologists
victimologists2262254vic_timologists
anthologist15410465_anth_ologist_
archaeologists20122815arch_aeologists
bryologists1745705___bryologists
cardiologists1765145_cardiologists
cetologist13412255_cet__ologist_
chronologist1857625_chronologist_
conchologists2154565_conchologists
cosmologists1746415_c_osmologists
cryptologists2155235_cryptologists
cytologist16410535_cyt__ologist_
ecologists13310925ec____ologists
embryologists2153125_embryologists
entomologists1655665_entomologists
ethnologist1549265__ethnologist_
ethologist14411895__eth_ologist_
etymologists18156495__etymologists
fetologists1547995_fet__ologists
futurologists1773075_futurologists
graphologists20123835graph_ologists
histologists1646295__histologists
horologists1548965__h_orologists
hydrologists2046095__hydrologists
ichnologies1746365ic__hnologi_es
ichthyoids2251885ichthy__o_i_ds
ideologists1346655i___deologists
immunologists18124495i_mmunologists
iridologists1444685i__ridologists
lichenologist1973915lich_enologist_
martyrologists2062895martyrologists
methodologists2153475methodologists
metrologists1588835_met_rologists
microbiologists22134815microbiologists
morphologists2154265morph_ologists
myologists1648205____myologists
mythologist2058995_myth_ologist_
nephrologists1954985_nephrologists
oceanologists1654305oc_eanologists
ontologists1248905_ont__ologists
ornithologists1852595ornith_ologists
osteologists1346765_ost_eologists
otologists1149635__ot__ologists
pathologist17410665_path_ologist_
petrologists1559145_pet_rologists
philologists1876685_ph_ilologists
phonologists1848775_ph_onologists
phrenologists1956295_phrenologists
phycologists2367135_ph_ycologists
physiologists22156015_physiologists
psephologists2155295pseph_ologists
psychologists24127475psych_ologists
rheologists1547315___rheologists
technologists19125705_technologists
theologises15106735___theologises
topologists1447865___topologists
trichologists1955425trich_ologists
typologists1746815___typologists
victimologist2162625vic_timologist_

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 Filter178691950240.343520965.0
2DLD Change Limit95024725.31317885.2
3Display Results72720.0461565.2
 (SQL Overall)178691725.70231338.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.