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

89 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
swanpan124369(None) 
shwanpan1641131shwanpan
swanpans1343421swanpans
sampan102511892s_ampan
shwanpans1741012shwanpans
swagman1334912swagman
wangan10311222_wangan
banian8315383_banian
banyan1139483_banyan
brainpan1243673brainpan
bwana10310243bwan_a_
bwanas1157443bwan_as
cancan10314103_cancan
claypan1434313claypan
deadpan11225233deadpan
japan14411233_ja_pan
kanban1238623_kanban
kwanza2232473kwanza_
kwanzas2342053kwanzas
mannan85413623_mannan
randan7315253_randan
salpa75018353s_alpa_
salpae84614273s_alpae
salpas85116923s_alpas
salpian938493s_alpian
saltpan935303saltpan
sampans112411003s_ampans
sandal73317283s_andal
sandman10310173s_andman
sanga66023793s_anga_
sangar73617683s_angar
sangas75222653s_angas
sanjak1735693s_anjak
sansar63613393s_ansar
saran53730303s_a_ran
scalepan1244513scalepan
scandal1038673scandal
seaman84015903sea_man
seawan94111223sea_wan
shaitan1036893shaitan
shaman113314283sha_man
shapen114414653sha_pen
sharpen12389723sharpen
span65234663s___pan
spartan948333spartan
standpat1145723standpat
stanza1537073stanza_
stanzas1636363stanzas
stewpan1234193stewpan
suntan62613003s_untan
swagmen1334973swagmen
swain84919053swa__in
swamp125015323swamp__
swamped15498443swamped
swamper14349313swamper
swamping16307923swamping
swampland1741983swampland
swamps135910263swamp_s
swampy16437233swamp_y
swan76631313sw___an
swang95519723swan__g
swank125318233swan__k
swanked15359543swanked
swanker14369483swanker
swanking16399963swanking
swanks134811563swan_ks
swanky16447973swan_ky
swanned11358173swanned
swanning12338813swanning
swanny12336823swan_ny
swans84625013swan__s
swanskin1543533swanskin
swap95925433swa_p__
swapped15429143swapped
swapper14359703swapper
swapping16348673swapping
swaps104819203swa_p_s
swaraj1636023swa_raj
swingman1443593swingman
taipan82410663_taipan
tampan102512323_tampan
tarpan82814293_tarpan
trapan82412973tra_pan
vanman1139793_vanman
wangans1149503_wangans
wangun1037103_wangun
wanigan1135213_wanigan
wanion93213063_wanion
wanton94413813_wanton

Search took 7 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 Limit134027896.20321606.8
3Display Results89890.0461934.8
 (SQL Overall)178691896.67226782.2
 
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.