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

102 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
stewpan123419(None) 
stewpans1343711stewpans
sewan85921292s_ew_an
steepen9348652steepen
teopan839352_teopan
bedpan1137583_bedpan
crewman1435743crewman
deewan10267553deew_an
dewan95718043_dew_an
etesian757853etesian
kneepan1372623kneepan
rewan85623663_rew_an
saltpan935303saltpan
sampan102511893s_ampan
seaman84015903s_eaman
seawan94111223s_eawan
secpar1037923s_ecpar
sedan65620423s_e_dan
seedman1037373seedman
seitan62613233s_eitan
sepal77723003s_e_pal
sewans95215903s_ew_ans
sewar85421093s_ew_ar
sewn76124333s_ew__n
sextan13389643s_extan
shebean1235763shebean
sheepman1543853sheepman
sheitan1036563sheitan
sherpa1138093sherpa_
sherpas1238093sherpas
shewn115715703shew__n
showman15257283showman
sierran737193sierran
skean94415623ske__an
snowman12226623snowman
span65234663s___pan
spean74620513spe__an
spelean937123spelean
stead65520273ste__ad
steak95219803ste__ak
steal56125473ste__al
steam76322923ste__am
steapsin1044713steapsin
stearin7312003stearin
steep76020703steep__
steeped103412283steeped
steepens10277113steepens
steeper93812773steeper
steeping113412583steeping
steeple937323steeple
steeply1236293steeply
steeps85215193steep_s
stein54620533ste__in
stela54019043ste_la_
stelae63716483ste_lae
stelai63912563ste_lai
stelar64013863ste_lar
stella63612973stella_
stellar72610413stellar
stellas72813033stellas
stemma10328133stemma_
stemmas11256973stemmas
stemson945163stemson
stengah1144553stengah
step67126293ste_p__
steppe10319873ste_ppe
stepped123210053stepped
stepper113010853stepper
steppes113110693steppes
stepping13329073stepping
steps76619883ste_p_s
stepson945663stepson
stern55319123ste__rn
sterna63712763sterna_
sternal73411903sternal
stetson745783stetson
stew77525463stew___
steward1138053steward
stewbum1442933stewbum
stewed104814243stew_ed
stewing113412493stewing
stews85519143stew__s
stewy116112063stew__y
stowp105614233stowp__
stowps115710583stowp_s
strewn96710003strew__n
stupa74112313st_upa_
stupas83910883st_upas
stygian1144083stygian
swan76631313s__w_an
swanpan1243693swanpan
taipan82410663_taipan
tampan102512323_tampan
tarpan82814293_tarpan
tenpin8310583_tenpin
teopans939203_teopans
tepa66021683_te_pa_
tepal76319583_te_pal
tepas76521683_te_pas
trapan82412973_trapan
trepan82511673_trepan
tympan13257013_tympan

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 Limit1340271026.87619492.0
3Display Results1021020.0303400.0
 (SQL Overall)1786911027.06225303.2
 
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.