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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
ponce9522251(None) 
nonce75719821nonce
once65423081_once
pence94924451pence
ponced114314811ponced
ponces104720841ponces
pone65747531pon_e
pounce105214091pounce
bocce114313112bocce
bone65949322bon_e
bonne75124712bonne
bonze165119352bonze
bounce104014832bounce
conch124620072conch
cone67256962con_e
conge85227592conge
conte76633202conte
dance85223132dance
dolce85816682dolce
done55747912don_e
donee66931012donee
donne65520462donne
douce85518422douce
dunce86319262dunce
fence105319912fence
force105324272force
gone55639042gon_e
hance105424152hance
hence104920052hence
hone77549322hon_e
jounce153310732jounce
lance75126722lance
lone45849132lon_e
longe66626462longe
mince95325232mince
monde85723142monde
monie75631652monie
monte75829772monte
nance74721842nance
nonces84418832nonces
none45743172non_e
oncet74626542_oncet
one37050912_on_e
ounce77019932ounce
pace86345772p_ace
pane64950292pan_e
panne76623652panne
peace95026082peace
pencel103812922pencel
penne75423852penne
phone105621932phon_e
pice84641092p_ice
piece96717992piece
pincer104019172pincer
pinch125619302pinch
pine67755712pin_e
place94824612place
poach124917862poach
pock126129292po_ck
poco86826152po_co
pointe84619312pointe
poise75127892poise
poke105335362po_ke
pole65951302po_le
police102918562police
pomace123111912pomace
pome85636692po_me
poncho133310122poncho
pond75530492pon_d
ponded105218772ponded
ponder94521692ponder
ponds85323402ponds
pones74547042pones
pong76231142pon_g
ponged105619352ponged
pongee94920192pongee
pongs85526342pongs
ponied94920702ponied
ponies84833462ponies
pons65850602pon_s
pontes83627852pontes
pony96434052pon_y
pooch124815302pooch
poove104514302poove
pope85535612po_pe
porch125918622porch
pore66451262po_re
pose66441732po_se
posse74722272posse
potence11711362potence
pouch124617082pouch
pounced123510622pounced
pouncer113511232pouncer
pounces114113892pounces
prance104318572prance
price93725412price
prince104114762prince
prone75332622pron_e
puce85127882p_uce
punch125118422punch
rance75028512rance
sconce104711722sconce
since75024172since
sonde64622832sonde
sone46649982son_e
spence103813792spence
sponge939662sponge
tone46953742ton_e
tonne54921432tonne
voice104915322voice
wince105220882wince
yince105214252yince
zonae145116442zonae
zone135231082zon_e

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.296603685.8
2DLD Change Limit538001141.71631352.0
3Display Results1141140.0333454.5
 (SQL Overall)1786911142.04587379.5
 
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.