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

101 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
jetsoms1612472(None) 
jetsams16124101jetsams
jetsom15126141jetsom_
besoms105712732be_soms
jetons134512612jet_ons
jetsam15116322jetsam_
jettons1437272jettons
atoms76817563_at_oms
besom95716973be_som_
besots86415453be_sots
bestows1248863bestows
betons84919553bet_ons
bettors93312473bettors
bosoms104913053_bosoms
bottoms1136993bottoms
celoms10412123ce_loms
censors93611833censors
cestos84718093cesto_s
customs11348263customs
deisms94411043deis_ms
estops84011223_estops
ethos85514193_etho_s
fathoms1537523fathoms
fatsoes10379423fatsoes
fatsos9389423fatso_s
fetors91014473fet_ors
fretsome1345853fretsome
genoms94412483ge_noms
gessoes838293gessoes
gjetosts1641893gjetosts
hansoms12238523hansoms
jatos125116823jat_o_s
jealous1438093jealous
jellos134714283jello_s
jerboas1636163jerboas
jerseys1733243jerseys
jess116022033je_s__s
jesses135215953je_sses
jesters144118193jesters
jests125922453je_s_ts
jetes124922843jet__es
jetfoil1742913jetfoil
jetfoils1842453jetfoils
jetlags1533863jetlags
jeton124815403jet_o_n
jetport1646643jetport
jetports1743533jetports
jets115834103jet___s
jetties143613123jetties
jettisons1642233jettisons
jetton1338033jetto_n
jetways2094053jetways
jisms14458003j_is_ms
kelsons1137323kelsons
ketols104210763ket_ols
ketoses114912873ketoses
ketosis11429733ketosis
lessons73811023lessons
lessors73610523lessors
mesons83215843me_sons
meteors94610013meteors
methods1338883methods
metols84115773met_ols
metros84217803metro_s
nelsons738003nelsons
nestors73614973nestors
netops839213net_ops
persons93717013persons
pesos77221623pe_so_s
pestos84719083pesto_s
petasos948603petaso_s
petrols92913083petrols
petrous92714423petrous
petsais938433petsais
ransoms92410163ransoms
reasons72514943reasons
resods74116303re_sods
resows93915353re_sows
reteams9339563reteams
retems83914573ret_ems
retools73411023retools
retrims93612373retrims
retros63820193retro_s
seasons72614233seasons
seisms84912143seis_ms
seisors73212833seisors
sensors73514633sensors
setons64620173set_ons
setous64917373set_ous
sitcoms1145533sitcoms
soms66239373___soms
stetsons845623stetsons
tatsois748373tatsois
telsons739223telsons
tensors72712373tensors
testons7313563testons
toms68343493__t_oms
venoms114211213ve_noms
versos93812803verso_s
vetoes92914083vet_oes
weasons102310583weasons

Search took 9 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.1561145455.1
2DLD Change Limit1340271018.29616155.6
3Display Results1011010.0462195.7
 (SQL Overall)1786911018.49821027.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.