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

201 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
quartos1632873(None) 
quartes163314931quartes
quarto153511121quarto_
quarts154715931quart_s
cuatros938272cuatros
quangos1734652quangos
quants153614142quant_s
quarks193810912quar_ks
quart144027852quart__
quartan1636422quartan
quartans1736282quartans
quarte154115322quart_e
quarter163211852quarter
quarters173110452quarters
quartet162814892quartet
quartets17277572quartets
quartic18258472quartic
quartics19216842quartics
quartz244212102quart_z
quartzes2645452quartzes
quartzose2751862quartzose
quartzous2742012quartzous
quatres163411932quatres
quirts154213552quirt_s
altos55822953__altos
anattos7138453anattos
arts49650263__art_s
arvos86015663__arvos
autos56523323__autos
boarts84716873boart_s
burritos1044473burritos
burros85114993bu_rros
burton8311273bu_rton
burtons9310853bu_rtons
cantos84826973_cantos
carbos105122263_carbos
cargos94619183_cargos
cartes86239473_cartes
carton84522663_carton
cartons94122473_cartons
cartop104213563_cartop
carts78946293_cart_s
charros124312143charros
charts115823093chart_s
claros84015113clar_os
cuatro838433cuatro_
curates95323833curates
curator9312213curator
curators10311723curators
curios83218333cu_rios
custos84014313cu_stos
darts67635733_dart_s
datos65222783_da_tos
dattos74311903_dattos
dearths11498843dearths
duros65422693du_r_os
earths95014593_earths
ecartes94212563ecartes
equates162012323equa_tes
equator1637483equa_tor
equators1737473equa_tors
espartos1044333espartos
euros54920243eu_r_os
faros85532023_far_os
farts88336843_fart_s
fugatos1135483fugatos
garths104111503_garths
guacos94410313gua_cos
guanos73811993gua_nos
guards84611573guar_ds
guars65021053guar__s
guiros7389093guir_os
harts88441593_hart_s
hearths135311073hearths
hearts96218943heart_s
hurts86922823hu_rt_s
jatos125116823_ja_tos
juntos134110843ju_ntos
jurats134213203jurat_s
karoos102415803_karoos
karts97630113_kart_s
kurtas10349883ku_rtas
largos74815063_largos
marts77442233_mart_s
mulattos1044083mulattos
narcos86714203_narcos
pantos85222743_pantos
pareos87023773_pareos
pargos95719043_pargos
parton84720993_parton
partons94620513_partons
parts77743373_part_s
parvos116614753_parvos
pharos11312063phar_os
puntos85915793pu_ntos
qats135331343q_a_t_s
quacks214710103qua_cks
quadrans1866363quadrans
quadrates19117803quadrates
quadrats1866483quadrats
quadrics2045653quadrics
quadroon1844473quadroon
quadroons1944183quadroons
quads154515843qua__ds
quaeres163310843quaeres
quaestor1743313quaestor
quaestors1843613quaestors
quaffs21125693qua_ffs
quaggas1893703quaggas
quags154613253qua__gs
quahog1944103qua_hog
quahogs2043163quahogs
quaichs2144633quaichs
quaighs2043493quaighs
quails153412643qua_ils
quais144618393qua__is
quakers20309693quakers
quakes194013343qua_kes
qualms17317243qua_lms
quango1636493quango_
quant143624813quant__
quanta153911333quant_a
quantal16367893quantal
quanted1738963quanted
quantic18279063quantic
quantics19276833quantics
quantong1843493quantong
quantongs1942313quantongs
quantum1845103quantum
quare143920543quar__e
quark184614123quar__k
quarrel1636103quarrel
quarrels1735083quarrels
quarries1749943quarries
quarry1837473quar_ry
quartern17286473quartern
quarterns18285153quarterns
quartier1737543quartier
quartiers1845183quartiers
quartile1747043quartile
quartiles1845603quartiles
quasars1646903quasars
quashes192110973quashes
quass144413763qua__ss
quasses16209503quasses
quate144521413qua_t_e
quatre153512353qua_tre
quavers19309013quavers
quays174612043qua__ys
qubits173710353qubit_s
qubytes2134383qubytes
queries16315873queries
querns15307943quer_ns
questor16146633questor
questors17147013questors
quests153310353quest_s
quiets154014373quiet_s
quietus16286393quietus
quilts154112543quilt_s
quintas163611713quintas
quintes164114713quintes
quints154316563quint_s
quires154015753quir_es
quirks19419113quir_ks
quirt144624233quirt__
quirted17369213quirted
quits144122353qu_it_s
quittor16285603quittor
quittors17155413quittors
quoits15379683quoit_s
quorums1843893quorums
quotas15339433qu_otas
quotes153312463qu_otes
qwertys224973qwertys
ratos55528763_ra_tos
rialtos736613rialtos
rubatos9278653rubatos
santos64421833_santos
sargos74318273_sargos
saros55238063_sar_os
sartor6313883_sartor
sartors7314973_sartors
scarts85321493scart_s
smaltos9408193smaltos
smarts86218003smart_s
squarers17338023squarers
squares163714463squar_es
squarks20417183squar_ks
squarrose1842393squarrose
squats153712963squa_t_s
squirts16348013squirt_s
starts65423123start_s
swarths13537323swarths
taros55640823_tar_os
tarots66422993_tarots
tarts57242023_tart_s
turacos938643turacos
turbos8910783tu_rbos
urates65027763_urates
warts814840403_wart_s
yurts87216533yu_rt_s

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.456391866.2
2DLD Change Limit1340272015.98322401.3
3Display Results2012010.0762644.7
 (SQL Overall)1786912016.51527427.6
 
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.