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

50 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
buzuki214276(None) 
buzukia2242221buzukia
buzukis2242661buzukis
adzuki2042522adzuki
azuki1864802_azuki
bouzouki2351202bouzouki
adzukis2141553adzukis
azukis1963733_azukis
bousouki1451563bousouki
bouzoukia245893bouzoukia
bouzoukis2451073bouzoukis
bubu85022673bubu__
bubus95115453bubu_s
buck125129903bu_ck_
bucko134614023bu_cko
bucks134824293bu_cks
buffi136112203bu_ffi
bulk105426153bu_lk_
bulks115920613bu_lks
bulky146215573bu_lky
bumkin14308083bu_mkin
bumpkin1743613bumpkin
bunk105731353bu_nk_
bunko115514513bu_nko
bunks115125083bu_nks
bunkum1435983bunkum
bupkus14385683bupkus
burka114617693bu_rka
burke115122763bu_rke
busk105429223bu_sk_
buskin123811493bu_skin
busks115521373bu_sks
butut75522913butu_t
bututs8409423bututs
buzz146617803buz__z
buzzed17408473buzzed
buzzer16379113buzzer
buzzes165011173buzzes
buzzwig2141993buzzwig
cumuli1036273cumuli
fumuli1135263fumuli
kabuki1143963kabuki
kulaki984293kulaki
lazuli1535363lazuli
muzhik2473523muzhik
muzjik2872703muzjik
rumaki1235133rumaki
saluki1036203saluki
tanuki1034913tanuki
tumuli835933tumuli

Search took 6 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.390458182.1
2DLD Change Limit112716505.42320784.8
3Display Results50500.0133846.2
 (SQL Overall)178691505.82630671.3
 
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.