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

129 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
quartan163643(None) 
quartans1736291quartans
aquarian1747012aquarian
partan83820572_partan
quanta153911332quanta_
quantal16367892quantal
quart144027852quart__
quarte154115332quart_e
quarter163211862quarter
quartern17286482quartern
quartes163314942quartes
quartet162814902quartet
quartic18258472quartic
quarto153511122quart_o
quartos16328742quartos
quarts154715942quart_s
quartz244212102quart_z
quatrain1745832quatrain
quintan16399222quintan
spartan948332spartan
tartan64217522_tartan
aquaria1638043aquaria_
aquarial1746633aquarial
aquarians1845873aquarians
artal55525483__artal
barman103519723_barman
buran75225303bu_r_an
burton8311273bu_rton
caftan111710123_caftan
captan101613343_captan
carman103920763_carman
carton84522663_carton
curran8312023cu_rran
curtain9319793cu_rtain
curtal83914543cu_rtal
durian7312003du_rian
furan84320013fu_r_an
guarana886303guar_ana
guarani8106273guar_ani
guardant1046443guardant
guardian1045113guardian
hartal9415483_hartal
hearten102411763hearten
kaftan13185833_kaftan
kurgan11126793ku_rgan
kurta95113923ku_rta_
kurtas10349893ku_rtas
lunarian847293lunarian
lurdan738363lu_rdan
marten84518263_marten
martian93514683_martian
martin84122523_martin
outran63218893outr_an
ovarian1037643ovarian
parian83223973_parian
partans94418283_partans
parton84720993_parton
platan83913693pla_tan
puritan939283puritan
quadrans1866363quadrans
quadrant1858083quadrant
quadrat1769273quadrat
quadrate1888053quadrate
quadrats1866483quadrats
quadroon1844473quadroon
quagga1754143quagga_
quaggas1893703quaggas
qualia1559563qualia_
quandang1943293quandang
quant143624813quant__
quanted1738973quanted
quantic18279063quantic
quanting1849233quanting
quantong1843493quantong
quants153614143quant_s
quantum1845103quantum
quare143920543quar__e
quark184614123quar__k
quarks193810913quar_ks
quarrel1636113quarrel
quarry1837473quar_ry
quarryman2351973quarryman
quarterns18285163quarterns
quarters173110463quarters
quartets17277583quartets
quartics19216853quartics
quartier1737553quartier
quartile1747053quartile
quartzes2645463quartzes
quasar1536843qua_sar
quassin1645943quassin
quate144521413qua_t_e
quatrains1845593quatrains
quatre153512363qua_tre
quatres163411943quatres
quean143612843qu__ean
quern143610403quer__n
quieten16258103quieten
quinta153312373quinta_
quintain17316223quintain
quintal16389883quintal
quintans17337873quintans
quintar16478603quintar
quintas163611713quintas
quintin163810333quintin
quirt144624233quirt__
quirted17369223quirted
quirting18238383quirting
quirts154213553quirt_s
quota145111963qu_ota_
quotas15339433qu_otas
ratan53722663_ra_tan
rattan63613603_rattan
rurban849043ru_rban
saran53730313_sar_an
saurian739913saurian
shaitan1036893shaitan
smarten9348863smarten
sultan63012593su_ltan
suntan62613003su_ntan
surtax1337843su_rtax
tarpan82814303_tarpan
tartana73010193_tartana
tartans72615823_tartans
tartar63214763_tartar
tarzan152910763_tarzan
turban8310483tu_rban
urban72013863_u_rban
yurta86014253yu_rta_

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271297.37318178.1
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.82522835.9
 
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.