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

43 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
quaintest184534(None) 
faintest1139072_faintest
quainter1765902quainte_r
quaintness1943202quaintness
quietest1757172qu_ietest
quintes164114712qu_intes_
quintet163914452qu_inte_t
quintets17347202qu_intets
squintest1845702squ_intest
aquatintist2062533aquatintist
brainiest11209723brainiest
daintiest1039153_daintiest
fainest10417703_fain_est
gauntest936603_gauntest
grainiest10188993grainiest
paintiest11310563_paintiest
plainest10313613plain_est
plaintext1863423plaintext
quackiest2435183quackiest
quaggiest2044173quaggiest
quaiches2235343quaiches_
quaint15415173quain___t
quaintly2065023quaint_ly
quakiest2138583qua_kiest
quakiness2236073quakin_ess
qualmiest2044393qualmiest
quanted1738963qua_nte_d
quants153614143qua_nt_s_
quartes163314933qua_rtes_
quartet162814893qua_rte_t
quartets17277573qua_rtets
quickest2345343qu_ickest
quietist1767493qu_ietist
quinces183210433qu_inces_
quintas163611713qu_intas_
quinte153414523qu_inte__
quintette1843173qu_intette
quints154316563qu_int_s_
rainiest81214923_rainiest
scantest101710183sca_ntest
squattest1844613squa_ttest
squintiest1944993squ_intiest
vainest10315763_vain_est

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.436409841.7
2DLD Change Limit148641437.44019978.6
3Display Results43430.0133307.7
 (SQL Overall)178691437.88922650.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.