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

167 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
quezal243514(None) 
quetzal2543011quetzal
quezals2544251quezals
quean143612842que_an
queazy2743572queazy
quell144311422que_ll
quetzals2642582quetzals
quezales2643462quezales
squeal1538012sque_al
acetal84314903acetal
areal55928733are_al
audial7312993audial
aural54428963au_ral
benzal1739643benzal
bezel165215173_bezel
bezil163812883_bezil
bubal94218213bu_bal
buccal1248243buccal
burial84117623burial
bursal84414823bursal
caecal103713733caecal
cecal94619113_cecal
coeval1138893coeval
credal9311673credal
cuneal8611513cuneal
curial84019153curial
curtal83914543curtal
cuspal1037883cuspal
daedal849083daedal
deal56347413_de_al
decal85523233_decal
dedal75719023_dedal
dual55928173du__al
ducal84816423du_cal
ductal938993ductal
duel56729703due__l
dural64923893du_ral
egal55119433__egal
equal1449823equ__al
faecal11359813faecal
feal713940423_fe_al
fecal105119213_fecal
feral85424653_feral
fetal85623373_fetal
feudal1037683feudal
foetal9311883foetal
fuel76824733fue__l
fugal95613033fu_gal
funeral1037623funeral
fungal10388733fungal
fuzil173810703fu_zil
haemal113811643haemal
heal75645693_he_al
hemal104419803_hemal
hiemal11339493hiemal
humeral1238563humeral
huzza1646093huzza_
huzzah2044423huzzah
huzzas1735863huzzas
hyetal1236543hyetal
ideal65716393ide_al
ileal56118083ile_al
jezail2234643_jezail
jugal135612403ju_gal
jumbal1758463jumbal
jural125120483ju_ral
juvenal1743393juvenal
leal46043273_le_al
legal65715943_legal
lienal63912783lienal
lumenal9307273lumenal
luteal64411483luteal
meal65643173_me_al
medal86221323_medal
metal75427383_metal
mezcal19367853_mezcal
mughal1236263mughal
mural75225103mu_ral
mutual838503mutual
neural6311993neural
nuchal11218873nuchal
numeral939083numeral
ouzel144612323ou_zel
peal68648103_pe_al
pedal86022503_pedal
penal75228373_penal
petal76526893_petal
plexal1536833plexal
puberal1147773puberal
pulpal10408453pulpal
pupal97616873pu_pal
qua124821973qu__a_
quad144618703qu__ad
quag144815943qu__ag
quai134420393qu__ai
quail144314363qu_ail
quale143617853qu__ale
qualm163511183qu__alm
quantal16367893quantal
quasar1536833quasar
quay164618353qu__ay
queans153110753queans
queasy1855173queasy
queen144312063que_en
queenly1944453queenly
queens15338873queens
queer143712813que_er
queerly1934223queerly
queers153510773queers
quelea1547303quelea
queleas1636723queleas
quells15359693quells
quench2036633quench
quern143610403que_rn
querns15307943querns
query174212083que_ry
quest144121323que_st
quests153310353quests
quetzales2741943quetzales
queue143711233que_ue
queued16336943queued
queuer15357253queuer
queues153510193queues
quey164616473que__y
queys17398363que_ys
quill148413763qu_ill
quinol15357973quinol
quintal16389883quintal
quiz224920003quiz__
quoll14379493qu_oll
quota145111963quota_
quotas15339433quotas
real45750293_re_al
regal65023793_regal
renal55929503_renal
ruderal837373ruderal
rueful948203rueful
rugal65916093ru_gal
rural55821173ru_ral
seal45654373_se_al
sepal77723003_sepal
seral56336383_seral
setal56430903_setal
sheal84927703she_al
squeak1935253sque_ak
squeals1636503sque_als
steal56125473ste_al
sulcal8311273sulcal
sural55931263su_ral
teal45546503_te_al
tepal76319583_tepal
thecal113310303thecal
thenal92712413thenal
tubal75517203tu_bal
tussal6288323tussal
ureal56722683_ureal
urial54823023_urial
usual5310183_usual
uveal84411073_uveal
veal76936813_ve_al
venal85523213_venal
vulval12417663vulval
weal75838683_we_al
wheal115716183whe_al
wurzel1834993wurzel
zeal135530333_ze_al
zoeal144813783zoe_al

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.186960704.3
2DLD Change Limit1127161676.70316815.8
3Display Results1671670.0632650.8
 (SQL Overall)1786911676.95225703.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.