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

53 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
ophthalmologist2610178(None) 
ophthalmologic2771542ophthalmologi_c
ophthalmologies2671602ophthalmologies
ophthalmology2761663ophthalmolog__y
ichthyologist2562785ichth__yologist
ophthalmoscopes29312035ophthalmoscopes_
ophthalmoscopic3181465ophthalmoscopi_c
pathologist17410665_path___ologist
philologist1768435_p__hil_ologist
phraseologist1954195_ph_raseologist
algologist1248246_____algologist
anthologist15410466_anth___ologist
anthropologist2064426_anthropologist
archaeologist19113496_archa_eologist
entomologist1556976_ent__omologist
epistemologist1972516ep_istemologist
ethnologist1549266__eth__nologist
ethologist14411896__eth___ologist
etymologist17158026__et__ymologist
hematologist18219206__hema_tologist
ichthyologists2662316ichth__yologists
methodologist2054316_meth_odologist
mythologist2059006_myth___ologist
oceanologist1555686o__cea_nologist
onomatologist1654406o_noma_tologist
ontologist11411366o_nt____ologist
ophthalmia20122806ophthalm____i_a
ophthalmias21132646ophthalm____ias
ophthalmic22123016ophthalm____i_c
ophthalmoscope28272206ophthalmo_scope
ophthalmoscopy31291756ophthalmo_scopy
ornithologist1753326ornith___ologist
osteologist1248566o_st___eologist
otologist10412816o__t____ologist
palynologist1856306_p___alynologist
pathologists1848376_path___ologists
petrologist14711886_pet___rologist
pharmacologist2464176_pharmacologist
philologists1876686_p__hil_ologists
phonologist17411566_p__h_onologist
photobiologist2266226_photobiologist
photogeologist21134676_photogeologist
phraseologists2053576_ph_raseologists
phrenologist1857916_p__hrenologist
phycologist2259186_p__h_ycologist
physiologist21157326_p__hysiologist
pomologist15412046_p____omologist
primatologist18175316_prima_tologist
pteridologist17144606_p_teridologist
speleologist1555746sp___eleologist
teleologist1249386___t_eleologist
thanatologist1753616___thanatologist
victimologist2162626vict__imologist

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 Filter178691950240.360496363.9
2DLD Change Limit95024538.00011878.0
3Display Results53530.0301766.7
 (SQL Overall)178691538.39021298.1
 
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.