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
quartile174705(None) 
quantile1747321quantile
quartiles1845611quartiles
quantiles1846602quantiles
quantize2645962quantize
quarte154115332quart__e
quartic18258472quarti_c
quartics19216852quartics
quartier1737552quartier
quartzite2742862quartzite
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
partible1238073_partible
particle1239543_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
quantized2844523quantized
quantizer2743973quantizer
quantizes2745713quantizes
quarantine1983693quarantine
quare143920543quar___e
quarrel1636113quarrel_
quarreled1963443quarreled
quarreler1863253quarreler
quarrels1735093quarrels
quarried1836103quarried
quarrier1736853quarrier
quarries1749953quarries
quart144027853quart___
quartan1636433quart_an
quartans1736293quartans
quarter163211863quart_er
quartered19155973quartered
quarterer18145723quarterer
quarterly2143713quarterly
quartern17286483quartern
quarters173110463quarters
quartes163314943quart_es
quartet162814903quart_et
quartets17277583quartets
quartette1843973quartette
quartiers1845193quartiers
quarto153511123quart__o
quartos16328743quart_os
quarts154715943quart__s
quartz244212103quart__z
quartzes2645463quartzes
quartzites2842423quartzites
quartzose2751873quartzose
quate144521413qua_t__e
quatre153512363qua_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 9 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.71618942.7
3Display Results98980.0332969.7
 (SQL Overall)178691988.15521911.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.