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

306 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
gospels103559(None) 
gospel936531gospel_
compels133210882compels
dispels10310502dispels
dossels85511602dossels
gaspers105014132gaspers
gospeler1173962gospeler
gospelers1273682gospelers
gospelly1443142gospelly
hosels94218602hos_els
hostels103712312hostels
losels64714582los_els
appels104312793_appels
aspens85013353_aspens
aspers86220313_aspers
boatels93510233boatels
bonspell1243163bonspell
bonspells1343193bonspells
bonspiels1342903bonspiels
boppers133911923boppers
bordels103911973bordels
boshes114721883boshe_s
boskets13409473boskets
bosses85925403bosse_s
botels84815803bo_tels
bowels114315593bo_wels
bushels124110713bushels
carpels115315463carpels
chapels14429153chapels
compel124412893compel_
coopers114019483coopers
copals105018943co_pals
copens106119963co_pens
copers104629843co_pers
copes97747103co_pe_s
coppers133519753coppers
copses104922473copse_s
corbels113813593corbels
cormels113813373cormels
cornels94716663cornels
cosecs105015213cos_ecs
coses76949493cos_e_s
cosets85824403cos_ets
coseys115215813cos_eys
coshers123618183coshers
coshes115022783coshe_s
cosies84932153cosie_s
cossets95014283cossets
costers94128333costers
costrels1038933costrels
coupes105022523coupe_s
couples115317053couples
cowpeas1437273cowpeas
cupels10310203_cupels
dispel9310323dispel_
donzels1735393donzels
dopers95522483do_pers
dopes84935043do_pe_s
dorpers104113173dorpers
dorsels84412573dorsels
dosers75723633dos_ers
doses65938503dos_e_s
dossals8379293dossals
dossel74813643dossel_
dossers84516233dossers
dosses76126273dosse_s
dossils8669773dossils
dottels8327783dottels
dowels104813343do_wels
easels65914553eas_els
expels1547173_expels
fosses96022083fosse_s
fossils10379013fossils
fosters104220103fosters
fusels94412453fus_els
gapers94520473g_apers
gapes86030823g_ape_s
gases65633993gas_e_s
gashes105725153gashe_s
gaskets12348153gaskets
gasless8319013gasless
gasped104814293gaspe_d
gasper94515543gaspe_r
gasps85415483gasp__s
gassers84714633gassers
gasses75724783gasse_s
gasters85624293gasters
gavels105911093g_avels
gawpers13448313gawpers
gels56836103g___els
gestes75721393geste_s
gimels938893g_imels
gippers123212083gippers
glossers9319053glossers
glosses84014123glosse_s
gnoses76515163gnos_e_s
goals65521293go__als
goatees82710443goatees
gobbets12327643gobbets
gobbles123512583gobbles
gobies95418063gobie_s
goblets103210183goblets
goboes95914443goboe_s
goddess1035263goddess
godets8410933go_dets
godless938403godless
goers65520253go__ers
goes55644093go__e_s
gofers104711513go_fers
goffers14409213goffers
goggles103510793goggles
goglets9379783goglets
goiters84014443goiters
golems939323go_lems
golfers114410083golfers
gomerels1144563gomerels
gomers94116883go_mers
gonefs10439873go_nefs
goners74420173go_ners
goobers10219623goobers
googols935483googols
gooneys11407073gooneys
goops86620963goop__s
goorals838703goorals
gooses75723053goose_s
gophers1338983gophers
gorals76917653go_rals
gores65740373go_re_s
gorgers94813643gorgers
gorges85321893gorge_s
gorgets94711783gorgets
gorhens1137183gorhens
gorps85316993gorp__s
gorses74723293gorse_s
gospeller1263743gospeller
gospellers1363013gospellers
gosport101010283gosport
gosports1185913gosports
gossans836783gossans
gossipers1263543gossipers
gossips1035903gossips
gossypols1551453gossypols
gougers94911763gougers
gouges86318693gouge_s
goxes135018263go_xe_s
grapes95123123grape_s
grapnels1134393grapnels
graspers11338403graspers
graupels1133103graupels
gravels113611143gravels
gripers104011463gripers
gripes94619873gripe_s
gropers104813853gropers
gropes95220403grope_s
grossers94410973grossers
grosses84517683grosse_s
groupers11358643groupers
grovels11427813grovels
gruels73910153g_ruels
gulpers10299013gulpers
gunnels8358563gunnels
gunsels8338133gunsels
gushers113512513gushers
gushes104719033gushe_s
gussets837443gussets
gyppers15235503gyppers
hassels104311013hassels
hoopers123616483hoopers
hopers114222973ho_pers
hopes105835643ho_pe_s
hoppers143115143hoppers
hopples142810713hopples
hosel86024813hos_el_
hosers95223963hos_ers
hoses85443173hos_e_s
hoseys124614003hos_eys
hosiers104212643hosiers
hostel93914153hostel_
hostess103210243hostess
hotels94515513ho_tels
housels105312133housels
hovels125413333ho_vels
impels10389523_impels
isohels1035393isohels
jaspers164310463jaspers
josephs19161833josephs
joshers174111593joshers
joshes165114853joshe_s
josses135117683josse_s
jostles143411143jostles
koels94613903ko__els
kopeks1134603ko_peks
koshers144811803koshers
lapels83712043_lapels
lispers94514323lispers
listels74212433listels
loopers93914033loopers
lopers84424143lo_pers
lopes76437343lo_pe_s
loppers113014103loppers
losel54419423los_el_
losers65123583los_ers
loses56742013los_e_s
losses65925233losse_s
loupes84918053loupe_s
mispens11311073mispens
missels94614813missels
models94216353mo_dels
mohels115011323mo_hels
mopeds11499663mo_peds
mopers104220373mo_pers
mopes95134983mo_pe_s
moppers133412463moppers
moppets13307163moppets
morels84820013mo_rels
morsels94112653morsels
moseys114711703mos_eys
moshers124017843moshers
moshes115222873moshe_s
mossers94116193mossers
mosses85527683mosse_s
motels83616893mo_tels
mussels9419843mussels
noels56418703no__els
nopals84914023no_pals
noses55435643nos_e_s
noshers103614333noshers
noshes96618233noshe_s
novels95512503no_vels
oosperm1134883oosperm
oosperms1243793oosperms
opals75718353_o_pals
opens76118553_o_pens
opes65942613_o_pe_s
oriels64914623_oriels
oses46641513_os_e_s
osiers63412793_osiers
osmols8137313_osmols
ospreys1233143_ospreys
ousels64815273_ousels
ouzels15408703_ouzels
passels93913023passels
pastels95215183pastels
pommels13235783pommels
popes95933813po_pe_s
poppers103414863poppers
poppets10338853poppets
popples103011873popples
posers84223973pos_ers
poses74642763pos_e_s
posies84431433posie_s
posoles9314883posoles
posses85128803posse_s
possess9419123possess
possets94212773possets
postals93716373postals
posters93928013posters
propels113412843propels
prospers123012263prospers
rappels11448803rappels
raspers94415923raspers
repels84318763_repels
respell947023respell
respells1056333respells
respelt9312143respelt
rompers113412243rompers
rondels82510053rondels
ronnels7318613ronnels
ropers84325903ro_pers
ropes75940063ro_pe_s
roses56445773ros_e_s
rosets65819953ros_ets
rosters73727543rosters
rowels94515453ro_wels
seels55632823__seels
sels46345983__s_els
soapers93715923soapers
sorels63921163so_rels
sorrels7310723sorrels
specs96916673__specs
speels85116393__speels
speils84116223__speils
spell75020303__spell
spells84617683__spells
spelt75430193__spelt
spelts84614643__spelts
spews105015923__spews
spiels85317953__spiels
stipels9418953stipels
tassels74510853tassels
topees85519703to_pees
topers85025323to_pers
topes76941763to_pe_s
toppers113914603toppers
topples113111653topples
toshes94520103toshe_s
tossers74713503tossers
tosses65225393tosse_s
toupees938513toupees
towels94314643to_wels
vespers1239033vespers
vessels1035933vessels
vowels124410483vo_wels
yodels104610073yo_dels
yokels13488063yo_kels
zosters163015413zosters

Search took 8 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.406440125.6
2DLD Change Limit1340273066.86019537.5
3Display Results3063060.1102781.8
 (SQL Overall)1786913067.37624226.0
 
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.