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 “serin” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

163 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
serin5543444(None) 
sarin55239251sarin
serein63318461serein
serif84132121serif
serine65432671serine
sering74731811sering
serins64029671serins
aerie54634602aerie
begin85117352begin
berlin83116372berlin
brin67038192_brin
burin75626062burin
ceria75125352ceria
ceric94023092ceric
cering94522532cering
eerie55228532eerie
ern35738352_er_n
eserine7415902eserine
estrin6315922estrin
feria85922712feria
ferine96422582ferine
fern76129322fer_n
grin55733722_grin
hemin103620932hemin
herein93717792herein
hern76134892her_n
heroin94420592heroin
heron85025502heron
jerid132316422jerid
jerkin17258112jerkin
kern85326212ker_n
levin84816412levin
merino8315092merino
merit7339182merit
merlin83916682merlin
mirin75023142mirin
pein65834942pe_in
pekin111514422pekin
peri65636972peri_
peril75425952peril
peris75537072peris
pterin81014152pterin
purin75527592purin
rein46040892re_in
renin54830032renin
repin75324702repin
reran57329102reran
rerig64018482rerig
rerun58722152rerun
resin54131052resin
rewin85623962rewin
rin36663182__rin
sabin74924942sabin
sain45551292s_ain
saran53730302saran
sari45444042sari_
sarins63932622sarins
saris54544952saris
sasin54626572sasin
satin55935212satin
savin84625082savin
scrim95419722scrim
scrip96619192scrip
searing83330922searing
sedan65620422sedan
seeing74222142seeing
seen46943122se_en
segni63712482segni
sei36048932se_i_
seif75638722se_if
seine55732872se_ine
seis45542392se_is
seisin63715122seisin
seizin153610842seizin
semen75724102semen
semi65127222semi_
semina8915562semina
semis74623532semis
sen36058522se__n
sepia75318672sepia
sepic94617052sepic
sequin1538522sequin
ser36752402ser__
sera46141392ser_a
serac75925202serac
serai56830162serai
serail64222672serail
serais64326132serais
seral56336382seral
sere46153472ser_e
sered65737292sered
sereins73716112sereins
serene63522352serene
serer55935502serer
seres55448892seres
serf76340112ser_f
serfs84922012serfs
serge64727462serge
serging93416672serging
serial64625852serial
sericin9312842sericin
series64540972series
serifs94017052serifs
serines74229542serines
seringa83310742seringa
sermon8413552sermon
serow86720442serow
serry84824122serry
sers45746652ser_s
serum75223472serum
serve85425962serve
serving113014982serving
servo84516682servo
seton55223542seton
seven84118312seven
sewan85921292sewan
sewing103819622sewing
sewn76124332se_wn
sexing144313892sexing
sherif122915232sherif
shin75634302s_hin
shri76021692shri_
shrine94920052shrine
shrink134511732shrink
shris84221442shris
sin36265892s__in
siren54525822siren
siring75128312siring
skein94814402skein
skin85927522s_kin
slain54923572slain
sori46039832sori_
soring74731882soring
sorn46641062sor_n
sozin14514522sozin
spin66231302s_pin
sprain83614862sprain
sprig85617742sprig
spring94526012spring
sprint84526792sprint
sprit76736402sprit
sri35634002s_ri_
sris45434152s_ris
stain55727932stain
stearin7312002stearin
stein54620532stein
steric8317062steric
stern55319122ster_n
strain64919572strain
stria55723202stria
string75327562string
strip77524332strip
suberin9314562suberin
swain84919052swain
syren85216742syren
syrinx1637142syrinx
tern46134802ter_n
vein75625752ve_in
venin85118662venin
verdin103113022verdin
vermin113414522vermin
xeric144315662xeric
zein135620602ze_in

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538001632.69020000.0
3Display Results1631630.0931752.7
 (SQL Overall)1786911632.87662131.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.