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

114 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
quartans173628(None) 
quartan1636421quartan_
aquarians1845872aquarians
partans94418282_partans
quadrans1866362quadrans
quarterns18285152quarterns
quarters173110452quarters
quartes163314932quart_es
quartets17277572quartets
quartics19216842quartics
quartos16328732quart_os
quarts154715932quart__s
quartzes2645452quartzes
quatrains1845582quatrains
quintans17337872quintans
tartans72615822_tartans
aquarian1747013aquarian_
burans85019303bu_r_ans
burtons9310853bu_rtons
caftans12179443_caftans
captans111612053_captans
cartons94122473_cartons
currans9310613cu_rrans
curtains10259703cu_rtains
curtals93111623cu_rtals
durians839573du_rians
furans94515953fu_r_ans
guarana886303guar_ana
guaranas995943guar_anas
guarani8106273guar_ani
guaranis996863guar_anis
guardant1046443guardant
guardants1143793guardants
guardians1143913guardians
hartals10313023_hartals
heartens113010153heartens
kaftans14185353_kaftans
kurgans12145653ku_rgans
kurtas10349883ku_rta_s
lunarians945513lunarians
lurdans837073lu_rdans
martens93714953_martens
martians103111613_martians
martins93322063_martins
parians93519733_parians
partan83820563_partan_
partons94620513_partons
platans93413123pla_tans
puritans1037633puritans
quadrant1858083quadrant
quadrants1965363quadrants
quadrates19117803quadrates
quadrats1866483quadrats
quadroons1944183quadroons
quaggas1893703quagga_s
quandang1943293quandang
quandangs2042253quandangs
quanta153911333quanta__
quantal16367893quanta_l
quantics19276833quantics
quanting1849233quanting
quantong1843493quantong
quantongs1942313quantongs
quants153614143quant__s
quarks193810913quar__ks
quarrels1735083quarrels
quarries1749943quarries
quart144027853quart___
quarte154115323quart__e
quarter163211853quart_er
quartern17286473quartern
quartet162814893quart_et
quartic18258473quart_ic
quartier1737543quartier
quartiers1845183quartiers
quartile1747043quartile
quartiles1845603quartiles
quarto153511123quart__o
quartz244212103quart__z
quartzose2751863quartzose
quartzous2742013quartzous
quasars1646903qua_sars
quassins1735793quassins
quatrain1745823quatrain
quatres163411933qua_tres
queans153110753qu__eans
querns15307943quer__ns
quietens17246343quietens
quintains18306033quintains
quintals17288003quintals
quintan16399223quintan_
quintars17337563quintars
quintas163611713quinta_s
quintins17329863quintins
quirting18238383quirting
quirts154213553quirt__s
quotas15339433qu_ota_s
ratans63819373_ra_tans
rattans73411953_rattans
sarans64224433_sar_ans
saurians837763saurians
shaitans1136413shaitans
smartass1044273smartass
smartens10286663smartens
spartan948333spartan_
sultans72411833su_ltans
suntans72111733su_ntans
tarpans92513533_tarpans
tartan64217513_tartan_
tartana73010193_tartana
tartanas8258893_tartanas
tartars73313403_tartars
tarzans16329923_tarzans
turbans939563tu_rbans

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.440406115.9
2DLD Change Limit1461621146.93621073.0
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.42224075.9
 
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.