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

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
hypnotherapists2810258(None) 
hypnotherapist27103271hypnotherapist_
hypnotherapies2773262hypnotherapi_es
chemotherapists2772474chemotherapists
hydrotherapies2663524hydrotherapi_es
hypnotherapy2862684hypnotherap___y
physiotherapist2892544physiotherapist_
radiotherapists21162584radiotherapists
aromatherapists2281665aromatherapists
chemotherapist2673245chemotherapist_
chronotherapies25122605chronotherapi_es
henotheists1754495h_enothe___ists
hypnotists1853885hypnot_____ists
hypothecations27132575hyp_othecations
hypothermias2554835hyp_other_mi_as
physiotherapies2872535physiotherapi_es
psychotherapist3083015psychotherapist_
radiotherapist20153315radiotherapist_
therapists1544405_____therapists
aromatherapist2172186aromatherapist_
chemotherapies2683136chemotherapi_es
cryotherapies2362786_cryotherapi_es
henotheisms1953756h_enothe___isms
henotheist1656716h_enothe___ist_
hydrotherapy2762686hydrotherap___y
hydrotropisms24102906hydrot__ropisms
hyperthermias2663626hyperther_mi_as
hypnotisms2053786hypnot_____isms
hypnotist1755646hypnot_____ist_
hypodermises2362866hyp_o_der_mises
hypothecate2463596hyp_otheca___te
hypothecates2573506hyp_otheca__tes
hypothecating2762536hyp_othecati_ng
hypothecation26152916hyp_othecati_on
hypothecators2661986hyp_otheca_tors
hypothenuses2362526hyp_othe__nuses
hypothermia2455236hyp_other_mi__a
hypothermic2655096hyp_other_mi__c
hypotheses2155766hyp_othe____ses
hypothesis2157256hyp_othe____sis
hypothesizes3253736hyp_othe__sizes
hypothyroidisms32121466hyp_othyroidisms
immunotherapies24122386immunotherapi_es
monotheists1654746_monothe___ists
psychotherapies3072996psychotherapi_es
radiotherapies2083216radiotherapi_es
synthesists1753276sy_n_the__sists
therapist1447086_____therapist_

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.343520965.0
2DLD Change Limit95024486.71614148.9
3Display Results48480.0331454.5
 (SQL Overall)178691487.09225196.1
 
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.