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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
esparto94423(None) 
espartos1044331espartos
apart74330673_apart_
biparty1445583biparty
depart94720563depart_
departs104310683departs
dispart101115283dispart_
disparts11109953disparts
earth85023053e__arth
ecarte84313503e_carte
embargo1243033embargo
epact94921533e_pact_
epacts105010393e_pacts
eparch13258423e_parch
escar74011993escar__
escargot1183863escargot
escarp10449003escar_p
escarps11397373escarps
escars83913133escar_s
escort84616483escort_
escorts9418403escorts
eskar9457453eskar__
eskars10357593eskar_s
espanol943783espanol
esprit8312843esp_rit
esprits938393esprits
estate64719763esta_te
expat14313813expa_t_
expats1537683expa_ts
expert15515353expert_
experts1659063experts
export15412183export_
exports1647983exports
impart102715143impart_
imparts11298533imparts
impasto11275193impasto
mispart111113783mispart_
misparts12108173misparts
panto76129413__panto
pareo74632603__pareo
pargo86723723__pargo
part65967463__part_
parton84720993__parton
parts77743373__parts
party106630613__party
parvo107719183__parvo
quarto153511123_quarto
restart7320033restart_
restarts8310873restarts
santo56227283_s_anto
sargo65424413_s_argo
sartor6313883_s_artor
scart76139773_scart_
scarts85321493_scarts
separate10310783separate
separator1146263separator
smalto84410283_smalto
smart75834093_smart_
smarts86218003_smarts
smarty115013793_smarty
spado83713703_spa_do
spait75631603_spait_
spaits85017473_spaits
spar65433303_spar__
spare75135563_spar_e
spared95427493_spared
sparer84524963_sparer
spares84834553_spares
sparge94216053_sparge
sparid94016933_sparid
spark114920893_spar_k
sparks124616363_sparks
sparky154511523_sparky
sparrow1234273_sparrow
sparry115111303_sparry
spars75431543_spar_s
sparse84516343_sparse
spartan948333_spartan
spat66548523_spa_t_
spate74731583_spa_te
spats75031383_spa_ts
spinto8410663_spinto
spirt75032953_spirt_
spirts85317133_spirts
sport75935983_sport_
sports84619183_sports
sporty115112493_sporty
sprat76635973_sprat_
sprats85819933_sprats
spurt77227983_spurt_
spurts84814973_spurts
start55642313_start_
starts65423123_starts
swart86234643_swart_
swarth126012083_swarth
swarty125812383_swarty

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 Limit134027967.26618445.8
3Display Results96960.0303200.0
 (SQL Overall)178691967.70223200.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.