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

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

303 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
pawnor1135724(None) 
pawner114212921pawner
pawnors12297201pawnors
fawner125910462fawner
manor78023922ma_nor
pallor8313672pallor
panner84224762panner
parlor8312672parlor
pastor84817482pastor
pavior1138532pavior
pawer104422972paw_er
pawn94625302pawn__
pawned124513282pawned
pawnee113115402pawnee
pawners124311072pawners
pawns108818132pawn_s
payor105413842pa_yor
prawner1246802prawner
spawner12347362spawner
yawner12428472yawner
abhor10411063_abhor
actor71116073_actor
algor6513053_algor
annoy869713_annoy
anoa45634473_a_noa
anon46134853_a_non
arbor74818113_arbor
ardor64617863_ardor
armor75118053_armor
awn68035913_awn__
awned96615953_awned
awns75324433_awn_s
awny105919303_awn_y
awol75620673_aw_ol
bailor83412603bailor
banner84421503banner
bawler114315053bawler
candor94516423candor
caner75334773ca_ner
canner84625983canner
cannon84514443cannon
cannot83616773cannot
canoe75627253ca_noe
canoer85121073ca_noer
canon74725303ca_non
cantor85621523cantor
captor104914603captor
castor84418533castor
damner95213433damner
darner74017303darner
dawn85624203dawn__
dawned113912093dawned
dawns95916593dawn_s
donor64418193_donor
downer104414923downer
earner63617223earner
factor11911453factor
fainer94717243fainer
fanner94218183fanner
fano75831683fa_no_
fanon84619013fa_non
fanos85926503fa_nos
fanwort13310733fanwort
favor114712453fa_vor
fawn105321953fawn__
fawned134910423fawned
fawners13388493fawners
fawnier13296363fawnier
fawns115914263fawn_s
fawny144711713fawn_y
gainer74117493gainer
ganof95420363ga_nof
garner73917003garner
gator64416033ga_tor
gawker14559353gawker
gawper12499693gawper
harbor11410723harbor
havior1248203havior
hawker164812663hawker
hawser125910843hawser
honor85718623_honor
jailor13418573jailor
kronor10417233kronor
labor75117313la_bor
lanner64920593lanner
lawn75925633lawn__
lawns85215423lawn_s
lawny115912013lawn_y
lawyer12386973lawyer
mahzor2035113mahzor
major145212923ma_jor
manner84020513manner
mano66536793ma_no_
manors84420883ma_nors
manos74933613ma_nos
mawn94424133mawn__
mayor106616623ma_yor
minor74920063_minor
nor38048823___nor
owner84613313_owner
pacer96131613pa_cer
pacier105018683pacier
packer144223403packer
padder103415493padder
padnag1036073padnag
paeon74819493pa_eon
paeons83915523paeons
pager84728203pa_ger
pagod95013683pa_god
pain65647243pain__
painch133511323painch
pained95622853pained
pains75138283pain_s
paint75443693pain_t
painter93814563painter
paints85921833paints
painty114714753painty
pair66031513pa__ir
pakora1247283pa_kora
paler75436933pa_ler
palier85023563palier
pallors9314343pallors
palmar104113463palmar
palmer105816543palmer
palter84423263palter
pamper124316663pamper
pan58466443pa_n__
panda85022613pa_nda
pander93725523pander
pandoor10358583pandoor
pandora1039543pandora
pandore10411853pandore
pandour10408213pandour
pandy115021173pa_ndy
pane64950283pa_n_e
paned85437183pa_ned
panel76023623pa_nel
panes76148693pa_nes
panfry14456413pa_nfry
pang75336283pa_n_g
panga85323533pa_nga
pangs84628663pa_ngs
panic93923903pa_nic
panier84425503panier
panino8315683panino_
panne76623653pa_nne
panned94123433panned
panners93621273panners
pannes85522853pannes
pannier93613353pannier
pans65855723pa_n_s
pansy105717973pa_nsy
pant66061253pa_n_t
panto76129413pa_nto
pantos85222743pantos
pantry115014103pa_ntry
pants76536923pa_nts
panty105929303pa_nty
panzer174213233panzer
paper95128663pa_per
par57467023pa___r
parador103311413parador
pardner10239473pardner
pardon94618733pardon
pareo74632603pareo_
pareos87023773pareos
parer75839903pa_rer
pargo86723723pargo_
pargos95719043pargos
parker124121373parker
parlors9312913parlors
parlour937263parlour
parol74826273pa_rol
parr65731153pa__rr
parrot8320663parrot
parser84822373parser
parson83817903parson
partner92811393partner
parton84720993parton
parvo107719183parvo_
parvos116614753parvos
paseo77022513paseo_
paseos88015813paseos
passer84721033passer
paster85734373paster
pastors94118993pastors
patentor1046373patentor
pater74740723pa_ter
pathos115516693pathos
patio74426353patio_
patios85221783patios
patrol83213023patrol
patron84018043patron
patter84628263patter
patzer173111643patzer
paunch13369853paunch
pauper103511943pauper
pauser84415963pauser
paver104225833pa_ver
paviors1237603paviors
paviour1244623paviour
paw87651173paw___
pawed115725613paw_ed
pawers114818783pawers
pawing124519553pawing
pawkier16236613pawkier
pawky173810153paw_ky
pawl95123263paw__l
pawls105617663paw_ls
pawnage1335873pawnage
pawnees12298173pawnees
pawning134711413pawning
pawnshop18102563pawnshop
pawpaw1653503pawpaw
paws96038183paw__s
payer105125723pa_yer
paynim1337363paynim
payors114312643pa_yors
penner84616663penner
pennon8310643pennon
pernod9310453pernod
pewter114013673pewter
phenol1149253phenol
phenom1339473phenom
phono104917023phono_
phonon114012033phonon
phonos114114793phonos
piano76118713piano_
pianos84315933pianos
pignora10306363pignora
pinner84521493pinner
pinon76024533p_inon
pinot78737293p_inot
pinwork16107243pinwork
pinworm1467173pinworm
plainer93811983plainer
planar84212713planar
planer84122653planer
planner93511623planner
plexor1535253plexor
poor65630223p__oor
porno75120653porno_
pornos85015253pornos
powder123611903powder
power105325953pow_er
powter114116033powter
powwow1342833powwow
praetor938973praetor
prawn105312433prawn__
prawned1346743prawned
prawners1346003prawners
prawns11509023prawn_s
pretor8315743pretor
prior74316173p_rior
pruner83413453pruner
punner84918153punner
rancor8810373rancor
raptor83912823raptor
rawer84623733raw_er
razor143012603ra_zor
sailor63113743sailor
salvor94711093salvor
saner54334323sa_ner
sannop837373sannop
sapor75119253sa_por
sartor6313873sartor
savior9710173savior
savor85417943sa_vor
sawer85026213saw_er
sawlog1035793sawlog
sawn75428163sawn__
sawney12387603sawney
sawyer12438043sawyer
senor53822793_senor
signor73510353signor
spanner94312563spanner
spanworm1544193spanworm
spawn107811713spawn__
spawned13316803spawned
spawners13396493spawners
spawns11577923spawn_s
spinor839943spinor
tabor75518393ta_bor
tailor63412503tailor
tanner63722283tanner
tannoy958353tannoy
tawer85223443taw_er
tawney12338233tawney
tawnier10318463tawnier
tawny114713653tawn_y
tenor53620253_tenor
vainer93714573vainer
valor83614893va_lor
vanner94215843vanner
vapor104013093va_por
wanner94019623wanner
warner93717223warner
yarner93313063yarner
yawn106219093yawn__
yawned13509843yawned
yawners13367183yawners
yawns114213273yawn_s
yawper14437953yawper

Search took 9 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.1431249587.4
2DLD Change Limit1127163037.86014340.5
3Display Results3033030.1701782.4
 (SQL Overall)1786913038.17321863.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.