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

58 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
psychohistories2872521psychohistories_
psychohistorian2882033psychohistori_an
psychohistory2972284psychohistor___y
protohistories1962825p_rotohistories_
psychiatries2263595psyc__hiat_ries_
psychobiologies2873725psychobiologies_
psychometries25125685psycho_met_ries_
ethnohistories2071856_ethnohistories_
prehistories1755346p___rehistories_
psychiatrist2273596psyc__hiat_ri_st
psychobiologist2874366psychobiologi_st
psychologies23127856psycho___logies_
psychometrics27154966psycho_met_rics_
psychopathies28114346psycho_pat_hies_
psychosurgeries2671866psychosurgeries_
psychrometries2663506psychromet_ries_
sociohistorical2281756_sociohistorical
biochemistries2371697biochemist_ries_
chemistries1854607___chemist_ries_
consistories1455087___consistories_
geochemistries2271677geochemist_ries_
histories12412477______histories_
polychotomies2562917polycho___tomies_
protohistorian1972707p_rotohistori_an
protohistorians2072147p_rotohistorians
protohistoric2062797p_rotohistori__c
psychiatric2353757psyc__hiat_ri__c
psychiatrists2362737psyc__hiat_rists
psychobiologic2963727psychobiologi__c
psychokineses27122857psychoki__neses_
psychokinesis27123537psychoki_nesi_s_
psycholinguist25163067psycholi_ngui_st
psychologise23107047psycho___logi_se
psychologised25144637psycho___logised
psychologises24136167psycho___logises
psychologism25126057psycho___logi_sm
psychologist23109117psycho___logi_st
psychologizes33135317psycho___logizes_
psychometric26105887psycho_met_ri__c
psychometrician2972037psycho_met_rician
psychomotor2362917psycho_motor____
psychoneuroses2472157psychoneuro_ses_
psychoneurosis2472457psychoneurosi_s_
psychoneurotics27102057psychoneurotics_
psychopathics30114227psycho_pat_hics_
psychophysicist3581907psychophys_ici_st
psychophysics3363507psychophys___ics_
psychoses1946687psycho__s____es_
psychosis1946797psycho__s___i_s_
psychosocial2493727psycho__s_oci_al
psychosurgeon2471927psycho__s_urgeon
psychosurgery2771887psycho__s_urgery
psychosyntheses3182267psychosyntheses_
psychotherapies3072997psychotherapies_
psychotics2255567psycho___t__ics_
psychotropics2764007psycho__tropics_
sophistries1653427_s__ophist_ries_
suppositories1771347_supposi_tories_

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 Limit95024587.59612509.7
3Display Results58580.0461260.9
 (SQL Overall)178691588.00222330.8
 
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.