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

74 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
quartiles184560(None) 
quantiles1846601quantiles
quartile1747041quartile_
quantile1747322quantile_
quantizes2745712quantizes
quarries1749942quarri_es
quartes163314932quart__es
quartics19216842quarti_cs
quartier1737542quarti_er
quartiers1845182quartiers
quartzes2645452quart_zes
quartzites2842412quartzites
quintiles1845982quintiles
aquarelles1952853aquarelles
articles10310243__articles
bastiles10313353_bastiles
curatives1437823curatives
dartles84014133_dart_les
duratives1346223duratives
hearties11315413hearti_es
hurtles103913753hu_rt_les
nargiles976793_nargiles
pantiles103617153_pantiles
particles1339803_particles
parties93230863_parti_es
quadrilles2044763quadrilles
quadruples2253313quadruples
quagmires2142303quagmires
quailed1737823qua__iled
quails153412643qua__il_s
qualities18311223qualities
quantics19276833quanti_cs
quantifies2244753quantifies
quantities1946293quantities
quantize2645963quantize_
quantized2844513quantized
quantizer2743973quantizer
quantizers2842913quantizers
quarantines2093343quarantines
quarreled1963433quarreled
quarreler1863243quarreler
quarrelers1962763quarrelers
quarrels1735083quarrel_s
quarried1836093quarri_ed
quarrier1736843quarri_er
quarriers1845183quarriers
quartans1736283quart_ans
quarte154115323quart__e_
quarter163211853quart__er
quartered19155963quartered
quarterer18145713quarterer
quarterers19124823quarterers
quarterlies2053653quarterlies
quarterns18285153quarterns
quarters173110453quart_ers
quartet162814893quart__et
quartets17277573quart_ets
quartettes1943793quartettes
quartic18258473quarti__c
quartos16328733quart__os
quarts154715933quart___s
quartzite2742853quartzite_
quartzose2751863quartzose
quartzous2742013quartzous
quatres163411933qua_t_res
quaysides2243283quaysides
queries16315873quer_i_es
quintile1736843quintile_
rutiles74315843ru__tiles
smarties10312873smarti_es
startles82111963start_les
surtitles945633su_rtitles
turtles72914343tu_rt_les
wartimes1336963_wartimes

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.406440125.6
2DLD Change Limit148641746.72022119.2
3Display Results74740.0302466.7
 (SQL Overall)178691747.15624970.8
 
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.