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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
quartiers184518(None) 
quarriers1845181quarriers
quarters173110451quart_ers
quartier1737541quartier_
partiers103514242_partiers
quantizers2842912quantizers
quarrier1736842quarrier_
quarries1749942quarrie_s
quarter163211852quart_er_
quarterers19124822quarterers
quartern17286472quart_ern
quarterns18285152quart_erns
quartes163314932quart_e_s
quartets17277572quart_ets
quartics19216842quarti_cs
quartiles1845602quartiles
quartzes2645452quartze_s
queriers1736962quer_iers
artier63419733__artier_
barriers104311893_barriers
barters94223043_bart_ers
buriers94017193bu_r_iers
bustiers103810053bu_stiers
carriers103614203_carriers
carters95327253_cart_ers
charters134115583chart_ers
courtiers1146703courtiers
curriers103410753cu_rriers
darters84017603_dart_ers
farriers113610743_farriers
furriers11369493fu_rriers
furthers1436493fu_rthers
garters84218233_gart_ers
guarders1035883guar_ders
harriers113712433_harriers
heartier1139103heartier_
hearties11315423heartie_s
hurriers11358893hu_rriers
hurters103413643hu_rt_ers
marriers103312473_marriers
murthers1336543mu_rthers
parriers103612903_parriers
partier93520713_partier_
parties93230863_partie_s
partners102711133_partners
partyers13277763_partyers
purtier93214093pu_rtier_
puttiers10288013pu_ttiers
quackier23215373quackier_
quaffers2333963qua_ffers
quaggier1933853quaggier_
quagmires2142303quagmires
quakers20309693qua__kers
quakier20239203qua_kier_
qualifiers2243333qualifiers
qualities18311223qualitie_s
qualmier1934563qualmier_
quantics19276833quanti_cs
quantifiers2352503quantifiers
quantiles1846603quantiles
quantizer2743973quantizer_
quantizes2745713quantizes
quarrelers1962763quarrelers
quarrels1735083quar_rels
quarried1836093quarrie_d
quartans1736283quart_ans
quarte154115323quart_e__
quartered19155963quart_ered
quarterer18145713quart_erer
quarterly2143703quart_erly
quartet162814893quart_e_t
quartic18258473quarti__c
quartile1747043quarti_le
quartos16328733quart__os
quarts154715933quart___s
quartzites2842413quartzites
quartzous2742013quartzous
quashers20186803qua_shers
quatres163411933qua_tre_s
quaverers2143853quaverers
quavers19309013qua__vers
querier16310013quer_ier_
queries16315873quer_ie_s
questers17168763quest_ers
quieters17248733quiet_ers
quilters17228433quilt_ers
quirkier2134163quirkier_
quitters17238523qu_itters
quoters16369263qu_ot_ers
saltiers83411953_saltiers
smarties10312873smartie_s
squarers17338023squar__ers
squatters1834943squa_tters
squattier1843713squattier_
squirters1835073squirt_ers
starters83714773start_ers
startlers9236743startlers
tarriers83411713_tarriers
tarsiers8298533_tarsiers
tartier74123263_tartier_
turtlers8258203tu_rtlers
variers103712663_var_iers
wartier103413913_wartier_

Search took 7 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.423422437.4
2DLD Change Limit1486411036.48322927.8
3Display Results1031030.0462239.1
 (SQL Overall)1786911036.95225703.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.