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

61 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
duckpin164346(None) 
duckpins1743691duckpins
duckie133511662duck_ie
ducking154315052duck_ing
duckling16247702duckling
backspin1845423backspin
buckeen1536703buckeen
bucking163617573buck_ing
buckling17259113buckling
buckskin1543573buckskin
bumkin14308083bumk_in
bumpkin1743613bumpkin
buskin123811493busk_in
cockpit1747993cockpit
decking153915593deck_ing
dickie133913113dick_ie
dicking153617613dick_ing
docking153615013dock_ing
dubbin11329263du_bbin
duci76422623duc__i_
duck115929173duck___
duckbill1742943duckbill
ducked144718013duck_ed
ducker134317993duck_er
duckers143214713duckers
duckier143911793duckier
duckies143613813duckies
ducklings17204013ducklings
ducks124823213duck__s
ducktail1542913ducktail
ducky154216113duck__y
ducting113713593duc_ting
duking124715133du_k_ing
dumping133712913du_mping
dunking133813263dunk_ing
dunlin739723du_nlin
duping104113633du__ping
dupping133711043du_pping
dusking133912053dusk_ing
dustbin1044543dustbin
dustpan1043243dustpan
fuchsin15124373fuchsin
fucking173212283fuck_ing
luckie123611413luck_ie
lucking143615833luck_ing
lupin75215843lu__pin
mucin93116823muc__in
mucking163213823muck_ing
nuclein966123nuclein
pumpkin1743523pumpkin
punkin123611523punk_in
pushpin1443233pushpin
rucking143216673ruck_ing
ruckling15258573ruckling
sculpin11236653sculpin
stickpin1643763stickpin
sucking143217413suck_ing
suckling152410023suckling
tucking143415183tuck_ing
unpin72613243_u_npin
yucking173211693yuck_ing

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.406440125.6
2DLD Change Limit134027616.46620728.0
3Display Results61610.0163812.5
 (SQL Overall)178691616.88825942.4
 
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.