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

80 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
psychologist2310911(None) 
psychologise23107041psychologise
psychologism25126051psychologism
psychologists24127471psychologists
phycologist2259182phyc_ologist
psephologist2056602psephologist
psychologic2456572psychologi_c
psychologies23127852psychologies
psychologised25144632psychologised
psychologises24136162psychologises
psychologisms26124772psychologisms
psychologize32145502psychologize
conchologist2055813conchologist
mycologist18410353_myc_ologist
mythologist2059003_mythologist
pathologist17410663p_athologist
phycologists2367133phyc_ologists
physiologist21157323physiologist
proctologist1758963proctologist
psephologists2155293psephologists
psychobiologist2874363psychobiologist
psycholinguist25163063psycholinguist
psychological2656593psychological
psychologising2662713psychologising
psychologized34144313psychologized
psychologizes33135313psychologizes
psychology2495533psycholog__y
sociologist1449883_sociologist
trichologist1856743trichologist
anthologist15410464_anthologist
bryologist1647384bry__ologist
conchologists2154564conchologists
cryptologist2056434cryptologist
cytologist16410534_cy_tologist
ecologist12314144__ec_ologist
escapologist1754484escapologist
ethologist14411894__ethologist
etymologist17158024ety_mologist
glaciologist1654894glaciologist
graphologist19114864graphologist
hydrologist1948334_hydrologist
morphologist2055504morphologist
musicologist1754284music_ologist
mycologists1947734_myc_ologists
myologist15411094_my__ologist
mythologists2146894_mythologists
necrologist14410134_necrologist
oncologist13410414_onc_ologist
osteologist1248564os_teologist
palynologist1856304palynologist
papyrologist2055094papyrologist
pathologists1848374p_athologists
pedologist14410864p__edologist
penologist13412844p__enologist
petrologist14711884p_etrologist
philologist1768434p_hilologist
phonologist17411564p_honologist
phrenologist1857914phrenologist
phycologies2247784phyc_ologies
physiologists22156014physiologists
piccoloist1654044p_iccolo_ist
pomologist15412044p__omologist
proctologists1856814proctologists
prologist12315084p___rologist
psephologies2044844psephologies
psychiatrist2273594psychiatrist
psycholinguists26182404psycholinguists
psychologizing3562724psychologizing
psychosis1946794psych__osis_
psychosocial2493724psychosocial
semiologist14410714_semiologist
serologist11413154_s_erologist
sexologist1849514_s_exologist
sinologist11510664_s_inologist
sociologists1547944_sociologists
speleologist1555744speleologist
syllogist13167144_sy__llogist
technologist18137404_technologist
trichologists1955424trichologists
typologist1648894_ty_pologist

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 Filter1786911247900.406440125.6
2DLD Change Limit124790806.65618748.5
3Display Results80800.0461739.1
 (SQL Overall)178691807.10825139.4
 
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.