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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

49 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
posttests114497(None) 
posttest10410231posttest_
coattests1143462coattests
mostests1036832mos_tests
postheats1447432postheats
postteens1144372postteens
attests7278813__attests
coattest1038863coattest_
contests103413383co_ntests
costless10310003costles_s
footrests12244503footrests
hostess103210243hos_tes_s
hottest10411383ho_ttest_
lostness837683lostnes_s
mostest9314793mos_test_
obtests9136233_o_btests
pastiest103319543pastiest_
pastless102411203pastles_s
pastness102510503pastnes_s
pestiest103018413pestiest_
phattest1336913phattest_
poetess938933po_etes_s
poetless1038723poetles_s
politest10312943politest_
portents103512823po_rtents
portless10310643portles_s
portress1038323portres_s
poshest12312423pos_hest_
poshness1356653poshnes_s
possess9419123pos_ses_s
possets94212773pos_se_ts
posteens10309733pos_teens
posterns102713723pos_terns
posters93928013pos_te_rs
posthaste1456603posthaste
posthastes1546273posthastes
postheat13411243postheat_
posties93128813postie__s
postposes1348193postposes
postteen1055693postte_en
posturists1247073posturists
potteens10256793po_tteens
potters94024343po_tte_rs
pottiest102815973pottiest_
poutiest103016793poutiest_
pretests10310013p_retests
prostheses1546553prostheses
prosthesis1546153prosthesis
protests10310493p_rotests

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 Filter1786911486410.1531167915.0
2DLD Change Limit148641497.78319098.2
3Display Results49490.0301633.3
 (SQL Overall)178691497.96622431.7
 
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.