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

48 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
psychotomimetic31111641psychotomimetic_
psychokinetic2963595psych__okinetic_
psychosomatic27113725psychoso__matic_
psychosomatics28113105psychoso__matics
photokinetic2374346p___hotokinetic_
psychodramatic2972076psycho_dramatic_
psychogenetic2664016psych__ogenetic_
psychometric26105886psych__o__metric_
psychometrics27154966psych__o__metrics
psychrometric27133916psych_ro__metric_
sympathomimetic288926_sympathomimetic_
dichotomization32101827_dichotomization
photometric2058607p___hoto__metric_
polychotomies2562917polychotomi_e___s
psychoacoustic2592247psycho_acoustic_
psychoacoustics2691917psycho_acoustics
psychoanalytic2972707psycho_analytic_
psychochemical3073157psych__o_chemical
psychodynamic3172927psychodynam__ic_
psychodynamics3272857psychodynam__ics
psychogenic2455417psych__o__genic_
psychokinesis27123537psych__okinesi_s
psychologic2456577psycholo____gic_
psychological2656597psycholo____gical
psychologies23127857psychologi_e___s
psychologise23107047psychologise____
psychologised25144637psychologise___d
psychologises24136167psychologise___s
psychologising2662717psychologi__sing
psychologist23109117psychologi_st___
psychologists24127477psychologi_st__s
psychologize32145507psychologize____
psychologized34144317psychologize___d
psychologizes33135317psychologize___s
psychologizing3562727psychologi__zing
psychometrician2972037psych__o__metrician
psychometries25125687psych__o__metries
psychometry2654277psych__o__met_ry
psychoneurotic26122357psycho_neurotic_
psychoneurotics27102057psycho_neurotics
psychotic2146897psych__o____tic_
psychotics2255567psych__o____tics
psychotropic2664487psychot___ropic_
psychotropics2764007psychot___ropics
psychrometer2453777psych_ro__met_er
psychrometers2563237psych_ro__meters
psychrometries2663507psych_ro__metries
psychrometry2762937psych_ro__met_ry

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.376475242.0
2DLD Change Limit95024487.40312835.9
3Display Results48480.0461043.5
 (SQL Overall)178691487.82522835.9
 
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.