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

98 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
quartile174704(None) 
quantile1747321quantile
quartiles1845601quartiles
quantiles1846602quantiles
quantize2645962quantize
quarte154115322quart__e
quartic18258472quarti_c
quartics19216842quartics
quartier1737542quartier
quartzite2742852quartzite
quintile1736842quintile
aquarelle1852963aquarelle
article9310923__article
artily92814713__artily
bastile9313913_bastile
curative13310403curative
dartle73714833_dart_le
ductile1048483du_ctile
durative1239073durative
fertile10311733_fertile
furtive1337173fu_rtive
futile93914953fu__tile
heartily1436563heartily
hurtle93512943hu_rt_le
nargile847653_nargile
pantile93918483_pantile
partible1238063_partible
particle1239533_particle
partite9317133_partite
puerile9310093puer_ile
quadrille1944913quadrille
quadruple2153313quadruple
quagmire2042383quagmire
quail144314363qua__il_
quailed1737823qua__iled
quails153412643qua__ils
quakily2336693qua_kily
quale143617853qua___le
quantal16367893quantal_
quantic18279063quanti_c
quantics19276833quantics
quantify2343863quantify
quanting1849233quanting
quantity2044733quantity
quantized2844513quantized
quantizer2743973quantizer
quantizes2745713quantizes
quarantine1983693quarantine
quare143920543quar___e
quarrel1636103quarrel_
quarreled1963433quarreled
quarreler1863243quarreler
quarrels1735083quarrels
quarried1836093quarried
quarrier1736843quarrier
quarries1749943quarries
quart144027853quart___
quartan1636423quart_an
quartans1736283quartans
quarter163211853quart_er
quartered19155963quartered
quarterer18145713quarterer
quarterly2143703quarterly
quartern17286473quartern
quarters173110453quarters
quartes163314933quart_es
quartet162814893quart_et
quartets17277573quartets
quartette1843963quartette
quartiers1845183quartiers
quarto153511123quart__o
quartos16328733quart_os
quarts154715933quart__s
quartz244212103quart__z
quartzes2645453quartzes
quartzites2842413quartzites
quartzose2751863quartzose
quate144521413qua_t__e
quatre153512353qua_t_re
quaylike2434143quaylike
quayside2143473quayside
quercine1964863quercine
quintiles1845983quintiles
quirkily2442593quirkily
quirting18238383quirting
rutile65217683ru__tile
smartie9310173smarti_e
squattily2142653squattily
startle72511123start_le
subtile91912623su_btile
surtitle845283su_rtitle
tactile9310613_tactile
tartily103511573_tartily
tortile7313193_tortile
tractile10311073tractile
turtle63213573tu_rt_le
utile54718933_u__tile
wartime1237743_wartime

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.406440125.6
2DLD Change Limit146162987.08020644.4
3Display Results98980.0303266.7
 (SQL Overall)178691987.51623774.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.