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

137 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
jetsom1512614(None) 
jetsam15116321jetsam
jetsoms16124721jetsoms
besom95716972be_som
jeton124815402jet_on
jets115834102jets__
jetsams16124102jetsams
jetton1338032jetton
atom67824523_at_om
besoms105712733be_soms
besot76429713be_sot
bestow1149463bestow
beton76022063bet_on
betook12439603betook
bets67051443bets__
bettor83612223bettor
bosom95516923_bosom
bottom1048723bottom
celom9515693ce_lom
censor84011293censor
cestoi84511953cestoi
cestos84718093cestos
custom104010273custom
deism84116033deis_m
detox13310953det_ox
estop74312103_estop
ethos85514193_ethos
fathom1437473fathom
fatso85113493fatso_
fatsos9389423fatsos
fetor81214533fet_or
fets75345943fets__
fretsome1345853fretsome
genom83716843ge_nom
gesso649603gesso_
gets55442483gets__
gjetost1543223gjetost
hansom11219153hansom
hets75547203hets__
jato115822683jat_o_
jatos125116823jat_os
jees115938543jees__
jello126716273jello_
jellos134714283jellos
jeon116821443je__on
jerboa1535633jerboa
jersey1636333jersey
jess116022033je_s_s
jesse126012833je_sse
jessed144112303jessed
jesses135215953jesses
jest116738503je_s_t
jested144416503jested
jester134319153jester
jests125922453je_sts
jet106754823jet___
jete115927253jet__e
jetes124922843jet_es
jetfoil1742913jetfoil
jetlag1434523jetlag
jetons134512613jetons
jetport1646643jetport
jetted143915083jetted
jettison1542503jettison
jettons1437273jettons
jetty156212583jet_ty
jetway19105273jetway
jews145822083jews__
jism135514773j_is_m
jots116336143jots__
juts115930163juts__
kelson1038153kelson
keto86223453ket_o_
ketol95414003ket_ol
ketose105711813ketose
lesson64412043lesson
lessor64010603lessor
lets47147943lets__
lissom837403lissom
meson74118313me_son
meteor84910073meteor
method1239023method
metol75917813met_ol
metro74718803metro_
metros84217803metros
nelson638423nelson
nestor63713423nestor
netop7312343net_op
nets45941533nets__
person83517873person
peso66925823pe_so_
pesos77221623pe_sos
pesto75723723pesto_
pestos84719083pestos
petasos948603petasos
petrol82714063petrol
pets66248333pets__
petsai838083petsai
petto76021043petto_
ransom82410943ransom
reason62616333reason
resod64720053re_sod
resow88217243re_sow
reteam83214533reteam
retem74221953ret_em
retook104313443retook
retool63914483retool
retrim83514883retrim
retro55020953retro_
retros63820193retros
rets45352563rets__
season62714903season
seism75019023seis_m
seisor63712343seisor
seldom939413seldom
sensor63813843sensor
sensum849353sensum
seton55223543set_on
setose65114773setose
sets45549503sets__
sitcom1036903sitcom
som59153813___som
stetson745783stetson
tatsoi637263tatsoi
telson6310293telson
tensor63812673tensor
teston6313303teston
tets45847463tets__
tom514358053__t_om
toom66532933__toom
venom103914863ve_nom
verso85314633verso_
versos93812803versos
veto76622993vet_o_
vets76835093vets__
weason93210823weason
wets75940293wets__

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.376475242.0
2DLD Change Limit1127161375.14021929.2
3Display Results1371370.0462978.3
 (SQL Overall)1786911375.56232127.1
 
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.