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

69 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
ophthalmologies267160(None) 
ophthalmologic2771542ophthalmologi_c
ophthalmologist26101782ophthalmologist
ophthalmology2761663ophthalmolog__y
ophthalmoscopes29312034ophthalmoscopes
ichthyologies2552295ichth__yologies
ophiologies1746015op__h__iologies
ophthalmias21132645ophthalm____ias
ophthalmoscope28272205ophthalmoscope_
ophthalmoscopic3181465ophthalmoscopi_c
paleologies1448585_p___aleologies
pathobiologies2274195_pathobiologies
pathologies1748735_path___ologies
philologies1747205_p__hil_ologies
phraseologies1953275_ph_raseologies
algologies1246796_____algologies
anthologies151012016_anth___ologies
anthropologies20113986_anthropologies
archaeologies1952826_archa_eologies
cohomologies2054056__coh_omologies
dactylologies2051806dact_yl_ologies
entomologies1575326_ent__omologies
epiphytologies2561416epiph_ytologies
epistemologies1962036ep_istemologies
eschatologies1952636_escha_tologies
ethnologies1547986__eth__nologies
ethologies14310546__eth___ologies
etymologies17176806__et__ymologies
exophthalmoses3171266exophthalm__o_ses
hagiologies1645346____hagiologies
haplologies1744766____haplologies
hematologies1847566__hema_tologies
homologies16311536____h_omologies
lithologies1546836_lith___ologies
methodologies2053486_meth_odologies
mythologies2047846_myth___ologies
oceanologies1554236o__cea_nologies
onomatologies1653386o_noma_tologies
ontologies1139886o_nt____ologies
ophthalmia20122806ophthalm____i_a
ophthalmic22123016ophthalm____i_c
ophthalmoscopy31291756ophthalmo_scopy
organologies1454086o__rga_nologies
orismologies1553296o___rismologies
ornithologies1752736ornith___ologies
osteologies1247056o_st___eologies
otologies10311406o__t____ologies
palynologies1844876_p___alynologies
petrologies1449896_pet___rologies
pharmacologies2463276_pharmacologies
phenologies1749356_p__h_enologies
phlebologies2054656_p__hlebologies
phonologies17410006_p__h_onologies
photobiologies2265156_photobiologies
photogeologies2163896_photogeologies
phrenologies1846316_p__hrenologies
phycologies2247786_p__h_ycologies
physiologies2155366_p__hysiologies
phytologies2049046_p__h_ytologies
pomologies15310046_p____omologies
praxeologies2293826_p__raxeologies
primatologies1863876_prima_tologies
pteridologies1762936_p_teridologies
speleologies1553886sp___eleologies
tautologies1245916___t_autologies
teleologies1247516___t_eleologies
thanatologies1752836___thanatologies
theologies141010106___th__eologies
victimologies2151766vict__imologies

Search took 8 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.360496363.9
2DLD Change Limit95024697.39012858.5
3Display Results69690.0461500.0
 (SQL Overall)178691697.79622920.9
 
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.