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

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

87 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
ophthalmologist26101781ophthalmologist_
ophthalmologic2771543ophthalmologi__c
ophthalmologies2671603ophthalmologi_es
ophthalmology2761664ophthalmolog___y
ichthyologist2562786ichth__yologist_
ichthyologists2662316ichth__yologists
ophthalmia20122806ophthalm____i__a
ophthalmoscopes29312036ophthalmoscopes__
ophthalmoscopic3181466ophthalmoscopi__c
pathologist17410666_path___ologist_
pathologists1848376_path___ologists
philologist1768436_p__hil_ologist_
philologists1876686_p__hil_ologists
phraseologist1954196_ph_raseologist_
phraseologists2053576_ph_raseologists
algologist1248247_____algologist_
algologists1346147_____algologists
anthologist15410467_anth___ologist_
anthologists1648037_anth___ologists
anthropologist2064427_anthropologist_
anthropologists2183417_anthropologists
archaeologist19113497_archa_eologist_
archaeologists20122817_archa_eologists
entomologist1556977_ent__omologist_
entomologists1655667_ent__omologists
epistemologist1972517ep_istemologist_
epistemologists2072127ep_istemologists
ethnologist1549267__eth__nologist_
ethnologists1647047__eth__nologists
ethologist14411897__eth___ologist_
ethologists1549027__eth___ologists
etymologist17158027__et__ymologist_
etymologists18156497__et__ymologists
hematologist18219207__hema_tologist_
hematologists19217057__hema_tologists
methodologist2054317_meth_odologist_
methodologists2153477_meth_odologists
mythologist2058997_myth___ologist_
mythologists2146897_myth___ologists
oceanologist1555687o__cea_nologist_
oceanologists1654307o__cea_nologists
onomatologist1654407o_noma_tologist_
onomatologists1753337o_noma_tologists
ontologist11411367o_nt____ologist_
ontologists1248907o_nt____ologists
ophthalmias21132647ophthalm____i_as
ophthalmic22123017ophthalm____i__c
ophthalmoscope28272207ophthalm__oscope
ophthalmoscopy31291757ophthalm__oscopy
ornithologist1753327ornith___ologist_
ornithologists1852597ornith___ologists
osteologist1248567o_st___eologist_
osteologists1346767o_st___eologists
otologist10412817o__t____ologist_
otologists1149637o__t____ologists
palynologist1856307_p___alynologist_
palynologists1954997_p___alynologists
petrologist14711887_pet___rologist_
petrologists1559147_pet___rologists
pharmacologist2464177_pharmacologist_
pharmacologists2573647_pharmacologists
phonologist17411567_p__h_onologist_
phonologists1848777_p__h_onologists
photobiologist2266227_photobiologist_
photobiologists2365177_photobiologists
photogeologist21134677_photogeologist_
photogeologists22173647_photogeologists
phrenologist1857917_p__hrenologist_
phrenologists1956297_p__hrenologists
phycologist2259187_p__h_ycologist_
phycologists2367137_p__h_ycologists
physiologist21157327_p__hysiologist_
physiologists22156017_p__hysiologists
pomologist15412047_p____omologist_
pomologists1648987_p____omologists
primatologist18175317_prima_tologist_
primatologists19184357_prima_tologists
pteridologist17144607_p_teridologist_
pteridologists18133727_p_teridologists
speleologist1555747sp___eleologist_
speleologists1654327sp___eleologists
teleologist1249387___t_eleologist_
teleologists1347227___t_eleologists
thanatologist1753617___thanatologist_
thanatologists1852867___thanatologists
victimologist2162627vict__imologist_
victimologists2262257vict__imologists

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 Limit95024877.56312564.3
3Display Results87870.0761144.7
 (SQL Overall)178691877.99922339.2
 
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.