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

88 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
nonce7571982(None) 
nance74721841nance
nonces84418831nonces
none45743171non_e
once65423081_once
ponce95222511ponce
bocce114313112bocce
bone65949322bon_e
bonne75124712bonne
bonze165119352bonze
bounce104014832bounce
conch124620072conch
cone67256962con_e
conge85227592conge
conte76633202conte
dance85223132dance
dolce85816682dolce
done55747912don_e
donee66931012donee
donne65520462donne
douce85518422douce
dunce86319262dunce
enounce937572enounce
fence105319912fence
force105324272force
gone55639042gon_e
hance105424152hance
hence104920042hence
hone77549322hon_e
jounce153310732jounce
lance75126722lance
lone45849132lon_e
longe66626462longe
mince95325232mince
monde85723142monde
monie75631652monie
monte75829772monte
nances83618642nances
nancy105214922nancy
nene45932062nen_e
nice65534712n_ice
niece74814502niece
nine45842172nin_e
noble74420992noble
nock106127182no_ck
node513036882no_de
noise55723732noise
nome66038422no_me
nona46929062non_a
nonage7313682nonage
nonas55126652nonas
noncom1039682noncom
noncore9411952noncore
nones55639132nones
nonet54540842nonet
nonmen8412832nonmen
nonuse63212252nonuse
nonyl849772nonyl
noose55624062noose
nope65934192no_pe
nose46739362no_se
notch105613322notch
note46239962no_te
notice8313442notice
novae85913122novae
novice1138432novice
nuance859042nuance
nuncle839362nuncle
oncet74626542_oncet
one37050912_on_e
ounce77019932ounce
pence94924452pence
ponced114314812ponced
ponces104720842ponces
pone65747532pon_e
pounce105214092pounce
rance75028512rance
sconce104711722sconce
since75024172since
sonde64622832sonde
sone46649982son_e
tone46953742ton_e
tonne54921432tonne
voice104915322voice
wince105220882wince
yince105214252yince
zonae145116442zonae
zone135231082zon_e

Search took 2 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.0762351197.4
2DLD Change Limit53800881.72031279.1
3Display Results88880.0165500.0
 (SQL Overall)178691881.81298615.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.