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

93 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
quartzes264545(None) 
quartes163314931quart_es
quantizes2745712quantizes
quarries1749942quarries
quartans1736282quartans
quarte154115322quart_e_
quarter163211852quart_er
quarters173110452quarters
quartet162814892quart_et
quartets17277572quartets
quartics19216842quartics
quartier1737542quartier
quartiers1845182quartiers
quartiles1845602quartiles
quartos16328732quart_os
quarts154715932quart__s
quartz244212102quartz__
quartzites2842412quartzites
quartzose2751862quartzose
quartzous2742012quartzous
quatres163411932qua_tres
bortzes1838223_bortzes
cartes86239473_cart_es
curarizes2078173curarizes
curates95323833curat_es
dartles84014133_dartles
dualizes1838823dualizes
ecartes94212563ecart_es
equalizes2747693equalizes
equates162012323equa_t_es
furzes186613693fu_r_zes
futzes184313113fu__tzes
hearties11315413hearties
hertzes1938303_hertzes
hurtles103913753hu_rtles
lutzes153711923lu__tzes
parties93230863_parties
putzes174212523pu__tzes
quadrates19117803quadrates
quaeres163310843qua_eres
quaiches2235343quaiches
quakes194013343qua__kes
qualities18311223qualities
quanted1738963quant_ed
quantics19276833quantics
quantiles1846603quantiles
quantize2645963quantize_
quantized2844513quantized
quantizer2743973quantizer
quantizers2842913quantizers
quants153614143quant__s
quare143920543quar__e_
quarks193810913quar__ks
quarrel1636103quar_rel
quarrels1735083quarrels
quarried1836093quarried
quarrier1736843quarrier
quarriers1845183quarriers
quart144027853quart___
quartan1636423quart_an
quartered19155963quartered
quarterer18145713quarterer
quarterers19124823quarterers
quartern17286473quartern
quarterns18285153quarterns
quartettes1943793quartettes
quartic18258473quart_ic
quartile1747043quartile
quarto153511123quart__o
quartzite2742853quartzite
quashes192110973qua_shes
quasses16209503qua_sses
quate144521413qua_t_e_
quatorzes2743123quatorzes
quatre153512353qua_tre_
quayages2144213quayages
qubytes2134383qubyt_es
queries16315873quer_ies
quintes164114713quint_es
quires154015753quir__es
quirted17369213quirt_ed
quirts154213553quirt__s
quizzes2435573qu_izzes
quotes153312463qu_ot_es
qurshes19228573qu_rshes
shvartzes2442103shvartzes
smarties10312873smarties
squares163714463squar__es
startles82111963startles
turtles72914343tu_rtles
urates65027763_urat_es
waltzes1935953_waltzes
yutzes18408413yu__tzes

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 Limit146162937.22020244.0
3Display Results93930.0303100.0
 (SQL Overall)178691937.67323288.3
 
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.