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

269 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
assists73847(None) 
assist6314601assist_
bassists1037181bassists
ageists848492ageists
agists75713172a_gists
aorists74215832aorists
artists74215592artists
aspises9611642aspises
assents74512222assents
asserts74311792asserts
assess65710462asses_s
assets65617662ass_ets
assigns836192assigns
assisted936232assisted
assister836752assister
assisters936352assisters
assistor844822assistor
assistors945252assistors
assizes1638452assizes
assorts73310152assorts
aurists74615782aurists
autists73814852autists
bassist9312742bassist_
cassises103811742cassises
casuists1036522casuists
classists11296242classists
coassists11275762coassists
desists83611722desists
fascists1336612fascists
insists739082insists
resists74414922resists
sadists83310852sadists
shists96515112_shists
ableists1036543ableists
abscises1246233abscises
absents93510723absents
absinth1244973absinth
absinths1342953absinths
accosts11107993accosts
addicts1176013addicts
adits66523713a_di_ts
adjusts1544513adjusts
admits9411413admi_ts
advises11138973advises
aegises8311373aegises
afrits9311903afri_ts
ageisms1056603ageisms
ageist7315383ageist_
agisms9399393a_gisms
agist66325583a_gist_
agonists9289833agonists
airts55626343a__irts
aits46355533a__i_ts
alist56136783a_list_
alsikes1137263alsikes
altoists848753altoists
ambits103713413ambi_ts
amiss75823073a_mis_s
amorists10411333amorists
angsts738863a_ngsts
animists103010633animists
anises64826693a_nises
anoints7311063anoints
aorist64827873aorist_
apsides103911303apsides
apsis75718293apsi__s
arises65233803a_rises
arista6415293a_rista
aristas7413523a_ristas
aristo6414033a_risto
aristos7312373a_ristos
aroints7313133aroints
arrests73312683arrests
arrises71617583arrises
arsines73518813arsines
arsis55722423arsi__s
arsonists947413arsonists
artist64125543artist_
artiste73813693artiste
artistes83213343artistes
asbestos1044353asbestos
asbestus1042953asbestus
ascents93812553ascents
asceses938623asceses
ascesis938373ascesis
ascites9312603ascites
ascots85312513a_scots
asdics9439863asdi_cs
asepses946363asepses
asepsis985903asepsis
ashiest10313953ashiest_
asides75118873a_sides
askeses1136463askeses
askesis1136123askesis
askings12519173askings
aspects1146743aspects
aspics104211563aspi_cs
aspires9612043aspires
aspis74618143aspi__s
aspish114810333aspis_h
assails769093assails
assais6711963ass_ais
assaults843863assaults
assays977903ass_ays
assent65119953assent_
assert64922583assert_
asses55629283a_s_ses
assesses737383assesses
asset55932263ass_et_
assign736783assi_gn
assignats1044003assignats
assistant944963assistant
assistants1053443assistants
assisting1046183assisting
assistive1244293assistive
assize1538633assi_ze
assoils776663assoils
assort64916383assort_
assumes967163assumes
assures7611403assures
astricts1049463astricts
atavists1137583atavists
atheists1138713atheists
atomists102610963atomists
attests7278813attests
audits72814113audi_ts
aurist65027253aurist_
autisms94311553autisms
autist64324943autist_
avisos95410483a_visos
awaits96411953awai_ts
axises134413993a_xises
baptists1236723baptists
bassets96414823bass_ets
bassetts10407373bassetts
bassinets1146323bassinets
bemists113410703bemists
bossisms1244703bossisms
cambists1437023cambists
cassias93514343cassi_as
cassinas103610633cassinas
cassines103116613cassines
cassinos10309353cassinos
cassis84818853cassi__s
casuist9411303casuist_
cists76624533__cists
classisms13295523classisms
classist104010383classist_
coassist10298803coassist_
consists10310593consists
cosmists1237993cosmists
cubists11359023cubists
dadaists1045583dadaists
dassies84418663dassi_es
deists74916433_deists
delists84414173delists
desist74818813desist_
egoists887073egoists
enlists749393enlists
essayists1242743essayists
exists134710913_exists
faddists13235543faddists
fascisms1545663fascisms
fascist1239213fascist_
fauvists1443843fauvists
feists94915313_feists
fists85527543__fists
foists95413983_foists
gassiest93212523gassiest_
gassings10438403gassings
gists66026193__gists
grists74716483_grists
harpists1338103harpists
hassiums1344273hassiums
heists96814633_heists
hists86328373__hists
hoists95516023_hoists
holists104413963holists
insist6314513insist_
jassids1586143jassi_ds
joists134711033_joists
jurists14409123jurists
kists95822113__kists
lassies74420103lassi_es
lassis65216703lassi__s
legists899593legists
lists56628693__lists
lutists73810273lutists
lyrists1036963lyrists
maists85817573_maists
massicots1343843massicots
massiest103314423massiest_
massifs1237743massi_fs
missises103513693missises
mists76633903__mists
monists93614783monists
mysosts1234543mysosts
narcists1078113narcists
nudists8356833nudists
oboists937903oboists
odists749853_odists
palmists12268813palmists
papists112110453papists
passings11409873passings
passions10310583passions
passives13228823passives
passivists1544003passivists
passuses1036773passuses
pastises103616053pastises
persists1049183persists
posits85718713posi_ts
purists94014073purists
racists92613323racists
rapists92510753rapists
relists73817053relists
resifts10378703resifts
resist64524533resist_
resits64725563resi_ts
sacrists1039563sacrists
sadisms10359113sadisms
sadist74221353sadist_
saints65122423_saints
sasins64923103sasi_ns
sasses64124393sas_ses
sassies74719263sassi_es
sassiest83413613sassiest_
schists1248543schists
seises64026713_seises
seisms84912143_seisms
sexists14267673sexists
shifts124412943_shifts
shirts94918343_shirts
shist84829613_shist_
shits84731173_shi_ts
sifts84918923__sifts
silts55330823__silts
sises55233833__sises
sisses64520603_sisses
sits45050203__si_ts
skirts104111503_skirts
skits94721863_ski_ts
slits56128853_sli_ts
snits54124833_sni_ts
spirts85317133_spirts
spits74429553_spi_ts
stilts67915313_stilts
stints65119763_stints
subsists1037993subsists
suints64617783_suints
suits55028053_sui_ts
swifts12408173_swifts
swiss86712903_swis_s
tachists1348183tachists
tanists7313653tanists
tassets75012773tass_ets
tassies74918933tassi_es
theists1039153theists
tsarists857303tsarists
tubists9288323tubists
tussises835433tussises
twists9549753_twists
typists1236173typists
verists103613673verists
vibists1256483vibists
visits9311423visi_ts
waists97415453_waists
whists124613813_whists
wists86728523__wists
wrists95415643_wrists

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 Limit1340272696.34321129.9
3Display Results2692690.1102445.5
 (SQL Overall)1786912696.59327103.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.