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 “quezam” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

65 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
quezal2435141quezal
quean143612842que_an
queazy2743572queazy
quetzal2543012quetzal
quezals2544252quezals
abeam9316533abe_am
beam86939233_be_am
bream95121813bre_am
cream95721353cre_am
dream85120393dre_am
dunam8313733du_nam
exam132514623__exam
fleam106017283fle_am
fulham1435303fulham
fullam1138363fullam
gleam86916733gle_am
huzza1646093huzza_
huzzah2044423huzzah
huzzas1735863huzzas
nizam16310253_nizam
qua124821973qu__a_
quad144618703qu__ad
quag144815943qu__ag
quai134420393qu__ai
qualm163511183qu_alm
quasar1536843quasar
quay164618353qu__ay
queans153110753queans
queasy1855173queasy
queen144312063que_en
queens15338873queens
queer143712813que_er
queers153510773queers
quelea1547303quelea
queleas1636723queleas
quell144311433que_ll
quells15359703quells
quench2036633quench
quern143610403que_rn
querns15307943querns
query174212083que_ry
quest144121323que_st
quests153310353quests
quetzals2642583quetzals
queue143711233que_ue
queued16336943queued
queuer15357253queuer
queues153510193queues
quey164616473que__y
queys17398363que_ys
quezales2643463quezales
quiz224920003quiz__
quondam1943303quondam
quorum1736023quorum
quota145111963quota_
quotas15339433quotas
ream65841613_re_am
seam66645973_se_am
shazam2046623shazam
squeak1935253sque_ak
squeal1538023sque_al
steam76322933ste_am
team66238653_te_am
unjam1448723_unjam
zuzim1534873zu_zim

Search took 8 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 Limit112716656.73316740.8
3Display Results65650.0164062.5
 (SQL Overall)178691657.15524974.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.