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

124 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
sporran93674(None) 
sporrans1045521sporrans
shoran94016032sho_ran
sierran737192sierran
sovran937152s_ovran
spartan948332spartan
sporal82915452spo_ral
apogean1045443apogean
aporia8315863aporia_
aporias9315153aporias
corban10314693_corban
corral83616253_corral
curran8312023_curran
doorman1037063doorman
foreran10311793_foreran
jordan1468063_jordan
loran55925093_lo_ran
morgan9311373_morgan
organ6915393__organ
orra46120723__orra_
overran10311663overran
parian83223963_parian
parral85517533_parral
partan83820563_partan
perron83216623_perron
porn65636023_po_r_n
portal84218463_portal
portray1237483_portray
potman102813573_potman
prolan8414693_prolan
pyran10514473_p_yran
saran53730303s__aran
saurian739913saurian
scoria8513493scoria_
scoriae9310903scoriae
scorn75817443sco_r_n
serrano768453s_errano
shopman14247253shopman
shorans102812403sho_rans
shorn85722173sho_r_n
shorten103511403shorten
showman15257283showman
sierra637313sierra_
sierras737863sierras
sirra54416323s_irra_
sirrah9379753s_irrah
sirras63814863s_irras
slogan7539223slo_gan
slurban944863slurban
snowman12226623snowman
socman1039813s_ocman
solan55328153s_o_lan
soldan73511853s_oldan
soman75024903s_o_man
soprani937403s_oprani
soprano937003s_oprano
sora45746913s_o_ra_
soras55041013s_o_ras
sorn46641063s_o_r_n
sororal7310653s_ororal
sorrel6413543s_orrel
sorrow9339443s_orrow
sorry84618253s_orr_y
sorta57125413s_orta_
soudan73210353s_oudan
sovrans1036483s_ovrans
span65234663sp___an
sparred104512853sparred
sparring113112223sparring
sparrow1234263sparrow
sparry115111303sparr_y
spean74620513sp__ean
spearman1244943spearman
spelean937123spelean
spheral1238423spheral
spiral83715343sp_iral
spirant9814293sp_irant
spirea84015633spirea_
spireas94412513spireas
spoken124610003spo_ken
spongin1036363spongin
sponsal946333sponsal
sponson935383sponson
spoon74719443spo__on
spoor75016353spoor__
spoored104411293spoored
spooring113111463spooring
spoors84014033spoor_s
spore75428593spo_r_e
spored94821793spo_red
spores84726613spo_res
sporing104319413sporing
sporoid102310723sporoid
sporozoan20143363sporozoan
sport75935983spo_r_t
sported104015433sported
sporter93616553sporter
sportif1238793sportif
sporting112415463sporting
sports84619183spo_rts
sportsman1343873sportsman
sporty115112493spo_rty
sporular1065223sporular
sporule937273sporule
spousal965533spousal
sprag86418693sp__rag
sprain83614863sp_rain
sprang95713523sp__rang
sprat76635973sp__rat
spray106720063sp__ray
spread9312533sp_read
spurn74815453sp_ur_n
spurred103610613spurred
spurrer93710213spurrer
spurrey12307803spurrey
spurring11339763spurring
spurry11429113spurr_y
storax1389783sto_rax
superfan1347453superfan
superman12310233superman
surra55521343s_urra_
surras65919533s_urras
swordman1443403swordman
sworn86115303swo_r_n

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.1561145455.1
2DLD Change Limit1340271247.01319111.2
3Display Results1241240.0502480.0
 (SQL Overall)1786911247.21924752.9
 
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.