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

211 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
quartz24421210(None) 
quart144027851quart_
quarte154115321quarte
quarto153511121quarto
quarts154715931quarts
quant143624812quant_
quanta153911332quanta
quants153614142quants
quare143920542quar_e
quark184614122quar_k
quarks193810912quarks
quarry1837472quarry
quartan1636422quartan
quarter163211852quarter
quartes163314932quartes
quartet162814892quartet
quartic18258472quartic
quartos16328732quartos
quartzes2645452quartzes
quate144521412qua_te
quatre153512352quatre
quirt144624232quirt_
quirts154213552quirts
apart74330673apart_
aquaria1638043aquaria
art38679143__art_
arts49650263__arts
arty77531313__arty
aurate64426473aurate
boart78835933boart_
boarts84716873boarts
bortz165722203_bortz
cart66570343_cart_
carte75940423_carte
carts78946293_carts
chart105038283chart_
charts115823093charts
cuatro838433cuatro
curate85226243curate
curt67051713cu_rt_
dart55857873_dart_
darts67635733_darts
dearth104212513dearth
earth85023053_earth
ecarte84313503ecarte
equate152012463equa_te
fart76860563_fart_
farts88336843_farts
futz167823803fu__tz
garth94720223_garth
guar56923293guar__
guard74415543guar_d
guards84611573guards
guars65021053guar_s
hart76865773_hart_
harts88441593_harts
heart85440743heart_
hearth125315213hearth
hearts96218943hearts
hearty126313633hearty
hertz174919043_hertz
hurt77142573hu_rt_
hurts86922823hu_rts
jurat124829323jurat_
jurats134213203jurats
kart86750803_kart_
karts97630113_karts
kurta95113913ku_rta
lutz136826323lu__tz
lyart85121883lyart_
mart66865983_mart_
marts77442233_marts
nertz145117453_nertz
part65967463_part_
parts77743373_parts
party106630613_party
peart76440753peart_
purty105019403pu_rty
putz158326323pu__tz
qat125253333q_a_t_
qats135331343q_a_ts
qua124821973qua___
quack203812503qua_ck
quacks214710103quacks
quacky24376963quacky
quad144618703qua__d
quadrat1769273quadrat
quadrate1888043quadrate
quadrats1866483quadrats
quadric1946313quadric
quads154515843qua_ds
quaere154110673quaere
quaeres163310843quaeres
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
quango1636493quango
quantal16367893quantal
quanted1738963quanted
quantic18279063quantic
quantize2645963quantize
quantum1845103quantum
quarrel1636103quarrel
quartans1736283quartans
quartern17286473quartern
quarters173110453quarters
quartets17277573quartets
quartics19216843quartics
quartier1737543quartier
quartile1747043quartile
quartzite2742853quartzite
quartzose2751863quartzose
quartzous2742013quartzous
quasar1536833quasar
quash174512163qua_sh
quasi144015023qua_si
quass144413763qua_ss
quatres163411933quatres
quaver18309313quaver
quay164618353qua__y
quays174612043qua_ys
qubit164218993qubit_
qubits173710353qubits
qubyte2034243qubyte
quern143610403quer_n
querns15307943querns
query174212083quer_y
quest144121323quest_
quests153310353quests
quiet144530733quiet_
quiets154014373quiets
quilt144125103quilt_
quilts154112543quilts
quint144529903quint_
quinta153312373quinta
quinte153414523quinte
quints154316563quints
quire144917133quir_e
quired163711953quired
quires154015753quires
quirk184011003quir_k
quirks19419113quirks
quirky22435533quirky
quirted17369213quirted
quit136136513qu_it_
quite144621463qu_ite
quits144122353qu_its
quiz224920003qu__iz
quoit143819863quoit_
quoits15379683quoits
quorum1736023quorum
quota145111963qu_ota
quote143714773qu_ote
quoth173310353qu_oth
qursh174110843qu_rsh
qwerty2133583qwerty
scart76139773scart_
scarts85321493scarts
smart75834093smart_
smarts86218003smarts
smarty115013793smarty
square154513363squar_e
squared173610563squared
squarer163410663squarer
squares163714463squares
squark19438113squar_k
squarks20417183squarks
squat143720143squa_t_
squats153712963squa_ts
squatty1964823squatty
squirt153812933squirt_
squirts16348013squirts
start55642313start_
starts65423123starts
swart86234643swart_
swarth126012083swarth
swarty125812383swarty
tart47566183_tart_
tarts57242023_tarts
tarty86328183_tarty
urate55432163_urate
waltz17615473_waltz
wart77866083_wart_
warts814840403_warts
warty119323823_warty
yurt76435043yu_rt_
yurta86014253yu_rta
yurts87216533yu_rts
yutz167519883yu__tz

Search took 6 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.406440125.6
2DLD Change Limit1127162115.35621044.8
3Display Results2112110.0633349.2
 (SQL Overall)1786912115.82530676.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.