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

228 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
quasar153683(None) 
quasars1646901quasars
bursar85413252bursar
hussar9317282hussar
pulsar8329362pulsar
quaker193811622quaker
quash174512162quas_h
quasher19198622quasher
quasi144015022quas_i
quass144413762quas_s
quaver18309312quaver
tussar6369542tussar
abaser86414343abaser
afar76720783__afar
agar58726413__agar
ajar116217703__ajar
alar46340073__alar
aquafarm22122153aquafarm
aquas142412613aquas__
aurar54420253au_rar
avatar937523avatar
basal75722283_basal
baser74828923_baser
bazar163816003_bazar
bulbar1039583bulbar
bursa74921523bursa_
bursae84515603bursae
bursal84414823bursal
bursars94510893bursars
bursary12397583bursary
bursas85318273bursas
busbar1038453busbar
caesar8410933caesar
casa65630863_casa_
casas75327843_casas
causal81413203causal
causer84117783causer
chadar1239353chadar
chaser114918383chaser
curser84721473curser
cursor84110293cursor
cusser86016093cusser
damar84117733_damar
durbar968723durbar
equator1637483equator
eraser64216333eraser
fubar1039923fu_bar
fulmar1137253fulmar
fusser94813773fusser
gazar154612983_gazar
guaiac946153guaiac
guanay1037913guanay
guar56923293gu__ar
guava938583guava_
guavas1037163guavas
guisard954203guisard
guitar7117443guitar
gular6314833gu_lar
haar77323493_ha_ar
hussars10326983hussars
kabar114815553_kabar
lahar83114263_lahar
lascar868573_lascar
laser54633323_laser
lazar144113643_lazar
leaser65322673leaser
lumbar103610593lumbar
lunar57017313lu_nar
lupanar963283lupanar
maar66025063_ma_ar
makar115614973_makar
malar76424443_malar
masa65034723_masa_
masas75630413_masas
maser75029973_maser
muggar10316443muggar
muser76024123mu_ser
nasal56217593_nasal
navar83912733_navar
nurser64314503nurser
omasa749483omasa_
oquassa1642063oquassa
oquassas1742113oquassas
osar46820953__osar
outsat62920283outsat
outsaw92610283outsaw
outsay92611873outsay
outsoar739493outsoar
outwar91011513outwar
pausal81511963pausal
pauser84415963pauser
planar84212713planar
pulsars9358913pulsars
pulser84215193pulser
purser85020473purser
qanat144426843q_anat
qindar16317173qindar
qintar15359143qintar
qua124821973qu__a_
quack203812503qua_ck
quacks214710103quacks
quacky24376963quacky
quad144618703qu__ad
quadrat1769273quadrat
quads154515843qua_ds
quaere154110673quaere
quaestor1743313quaestor
quaff201311353qua_ff
quaffer2235133quaffer
quaffs21125693quaffs
quag144815943qu__ag
quagga1754143quagga
quaggas1893703quaggas
quaggy2084683quaggy
quags154613253qua_gs
quahaug2042473quahaug
quahog1944103quahog
quai134420393qu__ai
quaich2047693quaich
quaigh1935463quaigh
quail144314363qua_il
quails153412643quails
quaint15415173quaint
quais144618393qua_is
quake184114643qua_ke
quaked203910033quaked
quakers20309693quakers
quakes194013343quakes
quakier20239203quakier
quaky214310743qua_ky
quale143617853qua_le
qualia1559563qualia
qualm163511183qua_lm
qualms17317243qualms
qualmy20285803qualmy
quamash2144293quamash
quandary2143433quandary
quango1636493quango
quant143624813qua_nt
quanta153911333quanta
quantal16367893quantal
quants153614143quants
quare143920543qua_re
quark184614123qua_rk
quarks193810913quarks
quarry1837473quarry
quart144027853qua_rt
quartan1636423quartan
quarte154115323quarte
quarter163211853quarter
quarto153511123quarto
quarts154715933quarts
quartz244212103quartz
quashed20207973quashed
quashers20186803quashers
quashes192110973quashes
quasses16209503quasses
quassia1644793quassia
quassias1754933quassias
quassin1645943quassin
quate144521413qua_te
quatre153512353quatre
quavers19309013quavers
quavery22225483quavery
quay164618353qu__ay
quayage2044573quayage
quays174612043qua_ys
quean143612843qu_ean
queasier1734473queasier
queasy1855173queas_y
queer143712813qu_eer
quest144121323ques_t
quester161410023quester
questor16146633questor
quests153310353quests
queuer15357253queuer
quezal2435143quezal
quinary1936933quinary
quintar16478603quintar
quiver18278743quiver
quota145111963quota_
quotas15339433quotas
quoter153510093quoter
qursh174110843qurs_h
radar61316723_radar
raser55633413_raser
ruana5312423ruana_
ruanas6311263ruanas
sansar63613393sansar
sarsar63011843sarsar
scalar83612433scalar
squalor1644423squalor
squama1736533squama_
squamae1845723squamae
squarer163410663squarer
squash1846833squas_h
squasher20185783squasher
squashy2233843squashy
suasory1046043suasory
suaver93014233suaver
subadar10125583subadar
subalar9118073subalar
subpar1048663subpar
sudser73511283sudser
sugar6312913su_gar
talar56225383_talar
tatar56122063_tatar
teaser65421523teaser
tsar47819803__tsar
tuatara745513tuatara
tussah9356233tussah
tussal6288323tussal
tussars7359253tussars
tusser64615833tusser
tussor6378233tussor
tussur6357293tussur
uakari1046863_uakari
ulnar56013983_ulnar
unbar71913613_unbar
unsay83212843_unsay
upsoar8105683_upsoar
ursa44116913_ursa_
ursae55214453_ursae
user45023003_u_ser
vasa76522973_vasa_
vasal85516293_vasal
vulgar10426823vulgar
vulvar12427963vulvar

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.373479064.3
2DLD Change Limit1127162285.33021147.5
3Display Results2282280.0802850.0
 (SQL Overall)1786912285.78330899.4
 
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.