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

92 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
jetsams1612410(None) 
jetsam15116321jetsam_
jetsoms16124721jetsoms
jetlags1533862jetlags
jetsom15126142jetsom_
jetways2094052jetways
petsais938432petsais
reteams9339562reteams
balsams11579013balsams
beams95328173be__ams
bedlams1237053bedlams
beldams1237053beldams
besoms105712733be_soms
betas75528763bet_a_s
betrays12127823betrays
bettas84913923betta_s
cestas85018543cesta_s
defoams1336193defoams
deisms94411043deis_ms
essays965653_essays
etas46432273_et_a_s
etnas54713933_etna_s
exams14199083_e_xams
ferbams1435743ferbams
fetas85624403fet_a_s
fetials103711743fetials
flotsams1343383flotsams
fretsaws1442763fretsaws
getas65421483get_a_s
hetmans12187593hetmans
jams135231073j___ams
jeans126022113je__ans
jehads1735833je_hads
jerseys1733243jerseys
jess116022033je_s__s
jessant1438443jessant
jesses135215953je_sses
jesters144118193jesters
jests125922453je_s_ts
jetbeads1842483jetbeads
jetes124922843jet__es
jetlag1434523jetla_g
jetons134512613jet_ons
jets115834103jet___s
jetstreams1951533jetstreams
jetties143613123jetties
jettons1437273jettons
jetway19105273jetwa_y
jigsaws1842563jigsaws
jimjams1742073jimjams
jisms14458003j_is_ms
jorams154810533j_orams
jotas125717443jot_a_s
lethals1038113lethals
matsahs1236563matsahs
mensas85115853mensa_s
mesas76823203me_sa_s
messans92710463messans
metals84520883met_als
outsays102710403outsays
petals84719813pet_als
petasos948603petasos
petasus946363petasus
petnaps1145033petnaps
petsai838083petsa_i
pitsaws1234993pitsaws
reams75729623re__ams
resaws93713513re_saws
resays93714153re_says
restamp1146483restamp
restamps1234703restamps
retags73414303ret_ags
reteam83214533reteam_
retears72814923retears
retems83914573ret_ems
retrims93612373retrims
seams75731663se__ams
seesaws1034703seesaws
seisms84912143seis_ms
sesame8311013se_same
sesames9310743se_sames
steams84916903_steams
tams67247933__t_ams
teams75726513__teams
tetrads82910193tetrads
tetras63017623tetra_s
trams75327673__trams
tsars56717113__tsars
vestals104612333vestals
vestas95916683vesta_s
webcams1643073webcams
zetas145018163zet_a_s

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 Filter1786911340270.1401276364.3
2DLD Change Limit134027926.20321606.8
3Display Results92920.0303066.7
 (SQL Overall)178691926.37328038.8
 
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.