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

265 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
quarto15351112(None) 
quart144027851quart_
quarte154115321quarte
quartos16328731quartos
quarts154715931quarts
quartz244212101quartz
cuatro838432cuatro
quango1636492quango
quant143624812quant_
quanta153911332quanta
quants153614142quants
quare143920542quar_e
quark184614122quar_k
quarks193810912quarks
quarry1837472quarry
quartan1636422quartan
quarter163211852quarter
quartes163314932quartes
quartet162814892quartet
quartic18258472quartic
quate144521412qua_te
quatre153512352quatre
quirt144624232quirt_
quirts154213552quirts
alto47831263__alto
anatto6139913anatto
apart74330673apart_
aquaria1638043aquaria
arco68331543__arco
art38679143__art_
arts49650263__arts
arty77531313__arty
arvo76023433__arvo
aurate64426473aurate
auto47432083__auto
boart78835933boart_
boarts84716873boarts
burrito936223burrito
burro75018493bu_rro
burton8311273bu_rton
canto74931013_canto
carbo94923843_carbo
cargo85322073_cargo
cart66570343_cart_
carte75940423_carte
carton84522663_carton
cartop104213563_cartop
carts78946293_carts
charro114212953charro
chart105038283chart_
charts115823093charts
claro75018693clar_o
cuatros938273cuatros
curate85226243curate
curator9312213curator
curio74221213cu_rio
curt67051713cu_rt_
dart55857873_dart_
darts67635733_darts
dato56129943_da_to
datto65416423_datto
dearth104212513dearth
duro56228023du_r_o
earth85023053_earth
ecarte84313503ecarte
equate152012463equa_te
equator1637483equa_tor
esparto944233esparto
euro45325273eu_r_o
faro76136923_far_o
fart76860563_fart_
farts88336843_farts
fugato1036223fugato
garth94720223_garth
guaco85012163gua_co
guano69213983gua_no
guar56923293guar__
guard74415543guar_d
guards84611573guards
guars65021053guar_s
guiro63712093guir_o
gusto65414643gu_sto
hart76865773_hart_
harts88441593_harts
heart85440743heart_
hearth125315213hearth
hearts96218943hearts
hearty126313633hearty
hurt77142573hu_rt_
hurts86922823hu_rts
jato115822683_ja_to
junto125114563ju_nto
jurat124829323jurat_
jurats134213203jurats
karoo92519583_karoo
kart86750803_kart_
karts97630113_karts
kurta95113913ku_rta
largo65319783_largo
lyart85121883lyart_
mart66865983_mart_
marts77442233_marts
mucro94513723mucr_o
mulatto944733mulatto
narco76718243_narco
panto76129413_panto
pareo74632603_pareo
pargo86723723_pargo
part65967463_part_
parton84720993_parton
parts77743373_parts
party106630613_party
parvo107719183_parvo
peart76440753peart_
punto75121323pu_nto
purty105019403pu_rty
putto75617663pu_tto
qat125253333q_a_t_
qats135331343q_a_ts
qua124821973qua___
quack203812503qua_ck
quacks214710103quacks
quacky24376963quacky
quad144618703qua__d
quadrat1769273quadrat
quadrate1888043quadrate
quadrats1866483quadrats
quadric1946313quadric
quadroon1844473quadroon
quads154515843qua_ds
quaere154110673quaere
quaeres163310843quaeres
quaestor1743313quaestor
quaff201311353qua_ff
quaffs21125693quaffs
quag144815943qua__g
quagga1754143quagga
quaggy2084683quaggy
quags154613253qua_gs
quahog1944103quahog
quai134420393qua__i
quaich2047693quaich
quaigh1935463quaigh
quail144314363qua_il
quails153412643quails
quaint15415173quaint
quais144618393qua_is
quake184114643qua_ke
quaked203910033quaked
quaker193811623quaker
quakes194013343quakes
quaky214310743qua_ky
quale143617853qua_le
qualia1559563qualia
quality1938563quality
qualm163511183qua_lm
qualms17317243qualms
qualmy20285803qualmy
quangos1734653quangos
quantal16367893quantal
quanted1738963quanted
quantic18279063quantic
quantong1843493quantong
quantum1845103quantum
quarrel1636103quarrel
quartans1736283quartans
quartern17286473quartern
quarters173110453quarters
quartets17277573quartets
quartics19216843quartics
quartier1737543quartier
quartile1747043quartile
quartzes2645453quartzes
quartzose2751863quartzose
quartzous2742013quartzous
quasar1536833quasar
quash174512163qua_sh
quasi144015023qua_si
quass144413763qua_ss
quatres163411933quatres
quaver18309313quaver
quay164618353qua__y
quays174612043qua_ys
qubit164218993qubit_
qubits173710353qubits
qubyte2034243qubyte
quern143610403quer_n
querns15307943querns
query174212083quer_y
quest144121323quest_
questor16146633questor
quests153310353quests
quiet144530733quiet_
quiets154014373quiets
quilt144125103quilt_
quilts154112543quilts
quint144529903quint_
quinta153312373quinta
quinte153414523quinte
quints154316563quints
quire144917133quir_e
quired163711953quired
quires154015743quires
quirk184011003quir_k
quirks19419113quirks
quirky22435533quirky
quirted17369213quirted
quit136136513qu_it_
quite144621463qu_ite
quits144122353qu_its
quittor16285603quittor
quoit143819863quoit_
quoits15379683quoits
quorum1736023quorum
quota145111963qu_ota
quote143714773qu_ote
quoth173310353qu_oth
qursh174110843qu_rsh
qwerty2133583qwerty
rato45436973_ra_to
rialto638603rialto
rubato8319683rubato
santo56227283_santo
sargo65424413_sargo
sartor6313873_sartor
scart76139773scart_
scarts85321493scarts
smalto84410283smalto
smart75834093smart_
smarts86218003smarts
smarty115013793smarty
square154513363squar_e
squared173610563squared
squarer163410663squarer
squares163714463squares
squark19438113squar_k
squarks20417183squarks
squat143720143squa_t_
squats153712963squa_ts
squatty1964823squatty
squirt153812933squirt_
squirts16348013squirts
start55642313start_
starts65423123starts
subito8410453subito
swart86234643swart_
swarth126012083swarth
swarty125812383swarty
tanto55724943_tanto
tardo65321103_tardo
taro46846913_tar_o
tarot55943933_tarot
tart47566183_tart_
tarts57242023_tarts
tarty86328183_tarty
turaco839453turaco
turbo71015043tu_rbo
unto45824283_u_nto
urate55432163_urate
wart77866083_wart_
warts814840403_warts
warty119323823_warty
yurt76435043yu_rt_
yurta86014253yu_rta
yurts87216533yu_rts

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 Filter1786911127160.720248181.9
2DLD Change Limit1127162655.42020796.3
3Display Results2652650.0803312.5
 (SQL Overall)1786912656.22028728.5
 
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.