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

93 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
phraseological228369(None) 
praxeological2554432p_raxeological
parasitological2062773parasitological
phraseologies1953273phraseologi_es
phraseologist1954193phraseologi_st
phraseologists2053573phraseologists
phrenological2156333phr_enological
physiological2455573ph_ysiological
chronological2175954chr_onological
graphological2253524_graphological
hagiological1955814_h_agiological
histological1846084_h_istological
museological1754784__museological
orismological1853624_orismological
pathological2047984p__athological
pharmacological2793544pharmacological
phenological2068054ph__enological
philological2046374ph__ilological
phonological2058374ph__onological
photogeological2463104photogeological
phraseology2052794phraseolog___y
phycological2546944ph__ycological
planetological1953174p_lanetological
prebiological2055974p_rebiological
prelogical1546694p_r__e_logical
proctological2055824p_roctological
radiological1646984__radiological
rheological17127474__r_heological
semasiological1983014semasiological
teratological1656114tera_tological
theological1798264th___eological
abiological1647835___abiological
aerobiological1955135aerobiological
algological1545975___algological
archaeological22152935archaeological
astrological1547025___astrological
axiological2146875___axiological
bryological1945375_br__yological
cardiological1954975car_diological
cosmological1946085__cosmological
cryptological2354795_cryptological
dermatological2053855dermatological
geological1448075____geological
gerontological1854175gerontological
glaciological1963915_glaciological
hematological2155945_hematological
herpetological2253325herpetological
homological1948445_h__omological
horological1748285_h__orological
hydrological2246485_h_ydrological
ideological15106645___ideological
karyological2274735__karyological
malacological2053975mala_cological
morphological2353965mor_phological
myrmecological2662645myrmecological
narratological1763095narratological
nematological1855665nema_tological
nonideological1862525nonideological
nontheological2063215nontheological
nosological1447375__nos_ological
osteological1546375__osteological
paleoecological2263555paleoecological
palynological2154675p_alynological
paraboloidal1762045para_bolo_idal
parasitologic1862255parasitologic__
pedological1757615p___edological
penological1648875p___enological
petrological1758595p__etrological
photobiological2564455photobiological
physiologic2254715ph_ysiologic__
physiologically2993605ph_ysiologically
pomological1848035p___omological
praxeologies2293825p_raxeologi_es
primatological2183215primatological
psephological2354985p_sephological
psychological2656595p_sychological
pteridological2053595pteridological
scatological1745545_sca_tological
seismological1873965_seismological
serological1468775____serological
somatological1854885soma_tological
speleological1853915_speleological
stereological1655675_stereological
tautological1555485__tautological
teleological1546575__teleological
terminological1953645terminological
thanatological2062505thanatological
thrasonical1652165thras___onical
tribological1745985_tr_ibological
tropological1746635_tr_opological
unideological1763335_unideological
urological1347755_ur___ological
virological1746305vir___ological

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 Limit95024936.87313825.7
3Display Results93930.0631476.2
 (SQL Overall)178691937.29624491.6
 
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.