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

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

81 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
bunko11551451(None) 
bucko134614021bucko
bunco94616081bunco
bunk105731351bunk_
bunkos124210321bunkos
bunks115125081bunks
banco94019392banco
banjo143812442banjo
bank105835742bank_
banks115527902banks
bento75922952bento
bingo86020092bingo
bongo85720942bongo
bonk105531712bonk_
bonks116326462bonks
bubo85621902bu_bo
buck125129902buck_
buckos143710892buckos
bucks134824292bucks
buffo135112182buffo
bulk105426152bulk_
bulks115920612bulks
bulky146215572bulky
bun56348142bun__
buna64730722bun_a
bunas75126572bunas
bunch125118602bunch
buncos104011592buncos
bund75530662bun_d
bunds85523542bunds
bundt85824852bundt
bung75730632bun_g
bungs85323862bungs
bunion83111312bunion
bunked135118372bunked
bunker124519372bunker
bunkoed14356662bunkoed
bunkum1435982bunkum
bunn65023652bun_n
bunns74718292bunns
bunny104715802bunny
buns66243722bun_s
bunt65850852bun_t
bunts75729802bunts
bunya103810092bunya
burka114617692burka
burke115122762burke
burro75018492burro
busk105429222busk_
busks115521372busks
buteo75419892buteo
dunk96228572dunk_
dunks105621192dunks
fungo94413132fungo
funk115825622funk_
funks125318912funks
funky154315132funky
gunk95423572gunk_
gunks104517722gunks
gunky135514112gunky
hunk116029542hunk_
hunks125321452hunks
hunky155417732hunky
junco144612202junco
junk155121032junk_
junks164815972junks
junky194513232junky
junto125114562junto
lunk86030722lunk_
lunks94822452lunks
mungo84916052mungo
pinko115618252pinko
punk105729972punk_
punka114515482punka
punks114822682punks
punky144419392punky
punto75121322punto
sunk85031812sunk_
unco66021402_unco
undo55620152_undo
unto45824282_unto

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit53800811.87628678.0
3Display Results81810.0302700.0
 (SQL Overall)178691811.99989390.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.