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

35 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
prosthetists175348(None) 
prosthetist1655881prosthetist_
prosthetics18135202prostheti_cs
anesthetists1552733anesthetists
prostatisms1555863prost_atisms
prostheses1546553prosthe__ses
prosthesis1546153prosthe__sis
prosthetic1797353prostheti__c
anesthetist1454034anesthetist_
nontheists1346064_nonthe_ists
orthotists1345154__orthotists
pantheists1546124p_anthe_ists
pastelists1245794p_ast_elists
phonetists1545414pho__netists
polytheists1994284polythe_ists
postheats1447434p_osthe__ats
posttests1144974p_ost__tests
posturists1247074p_ost_urists
proctitises15106324proct_itises
prophetess1744244pro_phetes_s
prosaists1157504pros___aists
proselytises1752814proselytises
proselytisms1962114proselytisms
prosodists1345944pros__odists
prostatism1447744prost_atis_m
prostatitis1355854prost_atitis
prostatitises1553814prostatitises
prosthodontists2171144prosthodontists
prostrations1449754prostrations
protests10310494pro_t_e__sts
protheses1449074pro_the__ses
prothesis1449434pro_the__sis
prothetic161010074pro_theti__c
protists10313364pro____tists
tritheists1344624tr_ithe_ists

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 Filter1786911247900.1431249587.4
2DLD Change Limit124790358.46614740.1
3Display Results35350.0162187.5
 (SQL Overall)178691358.62520717.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.