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

(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.

67 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
next116631081next
nexus124710661nexus
beau66137272beau
bedu75923692bedu
dex116936882dex_
dexy156118552dexy
eau37450942_eau
ecu56828232_ecu
emu55929982_emu
ex98835642_ex_
feu67843662fe_u
genu55929072genu
hex137436172hex_
jehu145614862jehu
jeu105532072je_u
jeux184311272jeux
kex146029582kex_
leku86519912leku
leu36047402le_u
lex107943822lex_
menu65130232menu
meou65325862meou
ne27045102ne__
neap66927012neap
near45236502near
neat46356782neat
neb57238622ne_b
nebs66124982nebs
neck105423662neck
nee36657782ne_e
need54934152need
neem67328082neem
neep65728312neep
neg47237342ne_g
negs55727362negs
negus64513562negus
neif75429492neif
nema65522522nema
nene45932062nene
neon47026422neon
nerd56624942nerd
ness45526562ness
nest45548732nest
net36670292ne_t
nets45941532nets
nett46643232nett
neuk87416602neuk
neum66723082neum
neve76224832neve
nevi75116422nevi
nevus84611392nevus
new66237092ne_w
news76127372news
newt76933742newt
nix106932832nix_
nixe115722022nixe
nixy145714512nixy
nu26331952n__u
rex105740992rex_
sex107043222sex_
sext117338092sext
sexy146418022sexy
text116033932text
vex136429172vex_
vext146927762vext
xu96018832__xu
zebu153414722zebu

Search took 1 second 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 Filter178691298720.0802233637.5
2DLD Change Limit29872670.81336742.9
3Display Results67670.0135153.8
 (SQL Overall)178691670.906197230.7
 
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.