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

181 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
abysms1356565(None) 
abysm12598141abysm_
abyss10669461abys_s
abases85720772abases
abohms1335002abohms
abuses85119102abuses
abyes105518532aby_es
abys97221882aby__s
abysmal1453972abysmal
abysses1234862abysses
agisms9399392agisms
abacas104414723abacas
abacus10349763abacus
abakas123911743abakas
abamp11310603ab_amp
abamps1236253abamps
abas68642083ab__as
abase76023483abas_e
abased96514993abased
abaser86414343abaser
abasers95311973abasers
abash106016513abas_h
abashes12510373abashes
abasia8712953abasia
abasias9711013abasias
abates85825033abates
abatis84317933abatis
abayas114011703abayas
abbas95918643ab_bas
abbes96723523ab_bes
abbess10509773abbess
abbeys13538423abbeys
abbots1039283abbots
abeam9316533abeam_
abeles84719393abeles
abets75621673ab_ets
abhors11410623abhors
abides94719893abides
abioses9311493abioses
abiosis939373abiosis
ableisms1245413ableisms
ables75935543ab_les
ablins8316193ablins
abmhos1334973abmhos
abodes94417513abodes
abohm1247973abohm_
aboma91114603ab_oma
abomas101113583abomas
aborts84916183aborts
abos67734413ab__os
aboves114512843aboves
abris75722603ab_ris
abs59356073ab___s
abuse77119563abus_e
abused95614273abused
abuser85413683abuser
abusers94710553abusers
abuts75417073ab_uts
aby810238063aby___
abye97921003aby__e
abying124410413abying
abyssal1243763abyssal
acyls104211523acy_ls
adeems946333adeems
ageisms1056603ageisms
agism84614063agism_
agists75713173agists
aims67738183a__ims
alarms85913053alarms
albums10198273albums
algums9208043algums
alms65834923a__lms
alums75720603a_lums
alyssums1341963alyssums
amass77119683amas_s
amiss75823073amis_s
amuses85117943amuses
amyls104512693amy_ls
amylums1473613amylums
angsts738863angsts
anises64826693anises
anuses66218773anuses
anyons94513503anyons
apses76823913a_pses
apsis75718293a_psis
arises65233803arises
arms66137493a__rms
arses55733873a_rses
arsis55722423a_rsis
arums75517833a_rums
aryls87015813ary_ls
asks85721213a__sks
asps65622093a__sps
ass37844063a__s_s
asses55629283a_sses
asylums1243633asylums
atoms76817563a_toms
aurums849383aurums
autisms94311553autisms
avisos95410483avisos
axioms15408053axioms
axises134413993axises
ayahs116813523a_yahs
ayes76543513a_y_es
ayins85321613a_yins
ays67050293a_y__s
azygos1933333azygos
baases85218013baases
babysat14135233babysat
babysit14145613babysit
babysits15143543babysits
balms95723923_balms
balsams11579013balsams
balsas86417523balsas
bams87044453_b_ams
barms96128463_barms
bases75644353_bases
basis75429863_basis
basks115621763_basks
bass66146783_bas_s
basses85428303basses
bassos85313703bassos
basts75936933_basts
bayamo1335603bayamo
bayamos1434663bayamos
bayous11411153bayous
bays97143913bay__s
beams95328173_beams
berms95323663_berms
beses75830723_beses
besoms105712733_besoms
bests75932613_bests
bises75435623_bises
bisks115416803_bisks
blams95023853_blams
booms95427123_booms
bosks115218853_bosks
bosoms104913053_bosoms
boss65938343_bos_s
brims94721623_brims
bums85934593_b_ums
buses75936013_buses
busks115521373_busks
buss65134913_bus_s
busts75227693_busts
byes95230533_by_es
byres104421383_byres
byrls105711233_byrls
bys85229463_by__s
byssi10507993_byssi
byssus1133763_byssus
bytes105217493_bytes
cambisms1645803cambisms
chasms135513143chasms
cubisms13306883cubisms
cysts105912773_cysts
deisms94411043deisms
favisms1535443favisms
gyms107514593_gy_ms
ibises83610543ibises
isms66213473__isms
jisms14458003_jisms
labrums1175853labrums
lyses84518253_lyses
lysis84511463_lysis
miasms1097383miasms
nanisms938833nanisms
obiisms1135673obiisms
pablums1345123pablums
papisms13238543papisms
physes14399783physes
physis14359663physis
plasms103711333plasms
prisms104915503prisms
racisms112310813racisms
sadisms10359113sadisms
seisms84912143seisms
spasms10418973spasms
trysts9448793trysts
xysts15558123_xysts
yams95330733__yams

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.403443402.0
2DLD Change Limit1127161815.45320670.5
3Display Results1811810.0632873.0
 (SQL Overall)1786911815.91930189.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.