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

139 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
quantal1636789(None) 
quanta153911331quanta_
quintal16389881quintal
cantal84122032_cantal
quant143624812quant__
quantally2144062quantally
quanted1738962quanted
quantic18279062quantic
quantile1747322quantile
quants153614142quant_s
quantum1845102quantum
quartan1636422quartan
quinta153312372quinta_
quintals17288002quintals
quintan16399222quintan
quintar16478602quintar
quintas163611712quintas
anal48037523__an_al
annal56520763__annal
anta46839583__anta_
antae56828293__antae
antas55432033__antas
antral65719413__antral
aquarial1746633aquarial
artal55525473__artal
banal75925993_ban_al
bantam10314063_bantam
brantail1046893brantail
canal75428043_can_al
cantala94114673_cantala
cantals93919573_cantals
canthal12410053_canthal
cental84420963_cental
chaetal1238283chaetal
coastal9411043coastal
cranial92114683cranial
cubital1137103cubital
cuneal8611513cu_neal
curtal83914543cu_rtal
dental74319173_dental
ductal938993du_ctal
fantail10310233_fantail
fatal84819373_fa_tal
faunal94711593faun_al
fontal9313143_fontal
fractal1237623fractal
frontal1038363frontal
fungal10388733fu_ngal
guanay1037913guan_ay
hartal9415473_hartal
hiatal9310203hia_tal
junta123713673ju_nta_
juntas134210503ju_ntas
kantar10311153_kantar
lanital7310913_lanital
manta75629913_manta_
mantas85725363_mantas
mantel84317973_mantel
manual8313463_manual
meatal84114733mea_tal
mental84521603_mental
natal53921493_na_tal
nunatak1142673nunatak
octantal1044563octantal
omental93210423omental
plantar9369993plantar
qanat144426843q_an_at
qanats154112813q_anats
qintar15359143q_intar
quadrantal2052693quadrantal
quadrat1769273quadrat
quagga1754143quagga_
quaggas1893703quaggas
quail144314363qua__il
quaint15415173quaint__
quainter1765903quainter
quaintly2065023quaintly
qualia1559563qualia_
quandang1943293quandang
quandary2143433quandary
quango1636493quan_go
quangos1734653quangos
quantics19276833quantics
quantify2343863quantify
quantiles1846603quantiles
quanting1849233quanting
quantity2044733quantity
quantize2645963quantize
quantong1843493quantong
quarrel1636103quarrel
quart144027853quart__
quartans1736283quartans
quarte154115323quart_e
quarter163211853quarter
quartes163314933quartes
quartet162814893quartet
quartic18258473quartic
quartile1747043quartile
quarto153511123quart_o
quartos16328733quartos
quarts154715933quart_s
quartz244212103quart_z
quasar1536833qua_sar
quate144521413qua_t_e
quatre153512353qua_tre
quetzal2543013quetzal
quezal2435143qu_ezal
quinate16511573quinate
quinela1635213quinela
quinnat16116823quinnat
quinoa15377653quinoa_
quinoas16337873quinoas
quinol15357973quin_ol
quint144529903quint__
quintain17316223quintain
quintans17337873quintans
quintars17337563quintars
quinte153414523quint_e
quintes164114713quintes
quintet163914453quintet
quintic18308883quintic
quintile1736843quintile
quintin163810333quintin
quints154316563quint_s
quondam1943303quondam
quota145111963qu_ota_
quotas15339433qu_otas
ratal55025113_ra_tal
rental63922023_rental
ruana5312423ruan_a_
ruanas6311263ruan_as
sandal73317283_sandal
santol64515243_santol
scandal1038673scandal
sonantal886263sonantal
statal61613223sta_tal
suntan62613003su_ntan
until53517743_u_ntil
vandal103713833_vandal

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271396.31321230.3
3Display Results1391390.0463021.7
 (SQL Overall)1786911396.76526414.0
 
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.