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

82 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
jigsaw174249(None) 
jigsawn1841581jigsawn
jigsaws1842561jigsaws
jigs126524762jigs__
jigsawed2041812jigsawed
pitsaw1135612pitsaw
ripsaw1134282ripsaw
bigs76235023bigs__
cigar8911793cig_ar
cigs75625103cigs__
digs66036053digs__
dipsas9359893dipsas
figs85332643figs__
giga66720943gig_a_
gigas75415583gig_as
gigs66631183gigs__
gnaw86515743__gnaw
jagra1338173jagra_
jagras1438463jagras
jags126132793jags__
jaguar1435283jaguar
jaw136237683j___aw
jetsam15116323jetsam
jiao115017843ji__ao
jibs136724083jibs__
jig115633513jig___
jigged164412773jigged
jigger155313053jigger
jiggle153811993jiggle
jiggly18378713jiggly
jiggy17549143jig_gy
jigsawing2141933jigsawing
jihad1635913ji_had
jingal1498583jingal
jins115635013jins__
jism135514773ji_s_m
jisms14458003ji_sms
jogs127129333jogs__
juga126417323jug_a_
jugal135612403jug_al
jugs125525603jugs__
ligan67920283lig_an
ligase7259913ligase
lignan75510323lignan
migs76935323migs__
missal84314903missal
missay114112143missay
outsaw92610283outsaw
pigs76634223pigs__
pigsty1235933pigsty
pilaw103913743pi_law
pitsaws1234993pitsaws
resaw84117253_resaw
rigs55137593rigs__
rikshaw1762873rikshaw
ringtaw1154353ringtaw
ripsawn1242503ripsawn
ripsaws1243823ripsaws
saw68255353___saw
seesaw935973seesaw
sightsaw1542693sightsaw
sigla64515203sigla_
sigma84513823sigma_
sigmas94111353sigmas
signa66114703signa_
signal73711483signal
sisal54217733si_sal
viga85622963vig_a_
vigas94817883vig_as
vigia94813273vigia_
vigias104110893vigias
vigs85427273vigs__
visa76323873vi_sa_
visas84317653vi_sas
warsaw1236193warsaw
whipsaw1842723whipsaw
wigan95114393wig_an
wigs84931253wigs__
wigwag1443723wigwag
wigwam1544723wigwam
zigs145422793zigs__
zigzag1642963zigzag

Search took 9 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 Filter1786911127160.203880251.2
2DLD Change Limit112716828.08013950.0
3Display Results82820.0461782.6
 (SQL Overall)178691828.32921454.1
 
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.