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

51 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
uniquest177560(None) 
uniques1667441uniques_
inquest1638602in_quest
unique1558162unique__
uniquely2043922uniquely
uniquer1675782unique_r
untruest847782untruest
acquest1837173_acquest
antiques1738883antiques_
bequest1837823_bequest
briquet1838833brique_t
briquets1934853briquets
caiques18248793caiques_
cinques1837333cinques_
cliques18309203cliques_
cliquiest2044093cliquiest
conquest1939553conquest
fiques1837973_fiques_
inquests1744943in_quests
luniest73516993luni__est
nicest82315663_ni_cest
nighest11310693_nighest
opaquest1943223opaquest
piques1739093_piques_
piquet17412353_pique_t
piquets1836603_piquets
puniest92918093puni__est
quest144121323___quest
request16311023_request
snidest8310913sni_dest
ubique1784883ubique__
unblest9411813un_blest
undrest8313013un_drest
unglues836993unglues_
unguent839123un_guent
ungues7412123un_gues_
unifies102714713unifies_
unionist8410353unionist
uniqueness1944513uniqueness
unites65024853uni_tes_
unities72520153unities_
unitrust845563unitrust
unjust1337873un_ju_st
unkindest1444993unkindest
unquiet16310663un_quiet
unquiets1744313un_quiets
unrest62918853un__rest
unripest1046083unripest
untidiest1046033untidiest
unwisest1165123unwisest
usques15126803u_sques_

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 Filter1786911461620.423422437.4
2DLD Change Limit146162516.75021653.6
3Display Results51510.0133923.1
 (SQL Overall)178691517.18624866.5
 
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.