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

123 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
seamark133672(None) 
seamarks1445301seamarks
demark134211022de_mark
earmark1345652_earmark
remark123512372re_mark
samara8313852s_amara
seaman84015902seama_n
seamer84223612seamer_
seamers94719432seamers
seaward1148182seaward
seaware1049632seaware
damar84117733_damar_
damars93814993_damars
damask1335843_damask
debark134210943de_bark
demarks14339233de_marks
earmarks1444793_earmarks
embark14458523_embark
finmark16154883finmark
gramary1355903gramary
mark105138063___mark
metalmark1752363metalmark
mismark1536703mismark
ostmark1344873ostmark
pugmark1643463pugmark
reamer84325213reamer_
reamers94221083reamers
reembark1643883reembark
remarks13329983re_marks
repark123511713re_park
safari91110223s_afari
salary9515213s_alary
samaras9312913s_amaras
sambar103914163s_ambar_
sambars115113843s_ambars
samek114915273s_am_ek
samsara936913s_amsara
sark84938973s___ark
satara6315533s_atara
scalar83612433scalar_
scalare93311833scalare
scalars93711903scalars
seabag938473seaba_g
seabags1037483seabags
seabird1055363seabird
seaboard1147433seaboard
seacock1545573seacock
seafarer1144843seafarer
seagirt8310153seagirt
sealant73118303sealant
sealer63928963sealer_
sealers74323553sealers
sealery104011053sealery
seam66645973seam___
seamanly1345403seamanly
seamed94823883seam_ed
seamen84518563seam_en
seamier93114633seamier
seaming103222113seaming
seamlike14127183seamlike
seams75731663seam__s
seamy105921273seam__y
seaport9315603seaport
sear47353843se__ar_
searer65432023searer_
sears54744913se__ars
seasick1346193seasick
seatback1675823seatback
seater64534163seater_
seaters74028943seaters
seatmate1048573seatmate
seatwork1546783seatwork
seawall1046203seawall
seawan94111223seawa_n
seawans10379943seawans
seawant103613413seawant
seawards1237203seawards
seawares1139333seawares
seaway12309993seawa_y
seaways13307513seaways
secpar1037923secpar_
secpars1138413secpars
sectary1238273sectary
seemer84418043seemer_
seemers93814333seemers
seggar8357813seggar_
seggars9377783seggars
selamlik1442093selamlik
sempre102710093se_mpre
senary93716073se_nary
setback1567143setback
sewar85421103se_war_
sewars94018633se_wars
shagbark1843113shagbark
shaman113314283shama_n
shamans123610903shamans
shamas113717943shama_s
shark126225023s__hark
siamang1045333siamang
simar74920813s_imar_
simars84916933s_imars
sitzmark2342023sitzmark
sjambok2242303sjambok
skylark1343273skylark
smack134615453s__mack
smarm95517603s__marm
smart75834093s__mart
smerk115412723s__merk
smirk116612753s__mirk
snark95419943s__nark
soapbark1643253soapbark
spark114920893s__park
spermary1545043spermary
squark19438113s_quark
stark95425623s__tark
steamer93313093steamer_
steamers103410873steamers
summary14297353summary
tamari8313403_tamari
teacart91113193teacart
teamwork1744563teamwork
teaware1048143teaware
telemark1444123telemark

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.423422437.4
2DLD Change Limit1340271237.15618729.3
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.62523434.9
 
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.