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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

72 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
abut66834953_abut
album92312653album
babu85829233babu_
babul96317713babul
babus95620333babus
bub76343983__bub
bubu85022673bubu_
bubus95115453bubus
bud67041273__bud
bug65340743__bug
bum75342693__bum
bun56348143__bun
bur55744693__bur
bus56950973__bus
but55963023__but
buy86436543__buy
debug94210063debug
debut86024143debut
habu97325483habu_
habus106317143habus
imbue939483imbue
nab56954923nab__
nabe66029493nab_e
nabes75427093nabes
nabis76020583nabis
nabob93913743nabob
nabs66236193nab_s
neb57238623neb__
nebs66124983neb_s
nebula857333nebula
nebule848753nebule
nebuly1135793nebuly
negus64513563negus
neuk87416603n_euk
neum66723083n_eum
nevus84611393nevus
nexus124710663nexus
nib56745193nib__
nibs65028313nib_s
nidus65913573nidus
nimbus10377283nimbus
nisus56014393nisus
nob58954423nob__
nobby125513463nobby
noble74420993noble
nobly105314403nobly
nobs66436903nob_s
nodus66315993nodus
notum7611693notum
noun45724183n_oun
nous46136983n_ous
nu26331953n__u_
nub56439143n__ub
nubby125011033nubby
nubia7311233nubia
nubs65927143nub_s
nubuck1434543nubuck
nun35537743n__un
nus37939393n__us
nut36651963n__ut
rebus75721113rebus
rebut75927383rebut
rebuy104714683rebuy
rubus76415063rubus
sebum93814553sebum
tabu66328493tabu_
tabun75914373tabun
tabus74820923tabus
zebu153414723zebu_
zebus164610053zebus
zouk174413543_zouk
zuz1110622033_z_uz

Search took 4 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 Filter178691836670.360496363.9
2DLD Change Limit83667723.17026393.4
3Display Results72720.0164500.0
 (SQL Overall)178691723.54650392.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.