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

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

100 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
teratologists149659(None) 
teratologist13108571teratologist_
dermatologists18134922dermatologists
hematologists19217052hematologists
nematologists16166602nematologists
teratologies1346872teratologi_es
cetologists1449163ce__tologists
deontologists1555923deontologists
dermatologist1786463dermatologist_
fetologists1547993fe__tologists
gerontologists1654853gerontologists
hematologist18219203hematologist_
herpetologists2083633herpetologists
narratologists1553213narratologists
nematologist15208473nematologist_
neonatologists1584193neonatologists
pteridologists18133723pteridologists
serologists12410123ser__ologists
technologists19125703technologists
teleologists1347223te_leologists
teratologic1455653teratologi__c
teratological1656113teratological
thanatologists1852863thanatologists
tribologists1546163t_ribologists
apologists1348884___apologists
bryologists1745704_br_yologists
cardiologists1765144cardiologists
cetologist13412254ce__tologist_
chronologists1966114chronologists
climatologists1983284climatologists
cryptologists2155234cryptologists
cytologists1748014__cytologists
demonologists1755564demonologists
dendrologists1654084dendrologists
deontologist1457414deontologist_
dermatologies1755254dermatologi_es
ecologists13310924_e__cologists
enologists11310624_e__nologists
escapologists1853344escapologists
ethnologists1647044_ethnologists
ethologists1549024_e_thologists
etymologists18156494_etymologists
fetologist14410404fe__tologist_
gemmologists1845234ge_mmologists
gemologists1577884ge__mologists
geologists1279164ge___ologists
gerontologist1555994gerontologist_
graphologists20123834_graphologists
hematologies1847564hematologi_es
herpetologist1984794herpetologist_
histologists1646294_histologists
horologists1548964hor__ologists
iridologists1444684_iridologists
lexicologists2374154lexicologists
malacologists1854404malacologists
metrologists1588834me_trologists
morphologists2154264morphologists
narratologist1453834narratologist_
necrologists1547874ne_crologists
nematologies1546694nematologi_es
neologists1139774ne___ologists
neonatologist14135354neonatologist_
nephrologists1954984nephrologists
neurologists1347644ne_urologists
oceanologists1654304oceanologists
onomatologists1753334onomatologists
ontologists1248904__ontologists
orologists1149824_or__ologists
otologists1149634___otologists
parasitologists1862814parasitologists
pathologists1848374__pathologists
pedologists1548274pe__dologists
penologists1449594pe__nologists
petrologists1559144pe_trologists
phraseologists2053574phraseologists
phrenologists1956294phrenologists
primatologists19184354primatologists
proctologists1856814proctologists
prologists13311174_pr__ologists
pteridologist17144604pteridologist_
radiologists1497374__radiologists
rheologists1547314__rheologists
rheumatologists2162254rheumatologists
seismologists16124194seismologists
selenologists1455334selenologists
semiologists1548224se_miologists
serologist11413154ser__ologist_
sexologists1947254se__xologists
technologist18137404technologist_
teleologist1249384te_leologist_
teratology1445294teratolog___y
thanatologist1753614thanatologist_
topologists1447864t__opologists
toxicologists2353984toxicologists
tribologist1447724t_ribologist_
trichologists1955424trichologists
typologists1746814t__ypologists
urbanologists1653254urbanologists
urologists1148414_ur__ologists
virologists1546634vir__ologists

Search took 7 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 Limit950241005.61016938.3
3Display Results1001000.0631587.3
 (SQL Overall)1786911006.03329618.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.