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

235 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
kronor1041723(None) 
kroner104612571kroner
kronur10415311kronur
donor64418192_donor
droner74717672droner
honor85718622_honor
ironer64216442ironer
krona93611792kron_a
krone94018732kron_e
kronen10348912kronen
kroon94514482kro_on
krooni10397182krooni
kroons103711242kroons
rotor55519732_rotor
arbor74818113ar_bor
ardor64617863ar_dor
armor75118053ar_mor
atoner64817193atoner
boner75133083_boner
boor66130683_bo_or
briner84519043briner
broker124314243broker
bromo95217203bromo_
bromos104213313bromos
bronc91714343bron_c
bronco10179493bronco
broncos11188073broncos
broncs101611153broncs
bronze173610923bronze
bronzer18348493bronzer
bronzy20306713bronzy
broo65129823bro_o_
brood84620243bro_od
brook114717763bro_ok
broom95022213bro_om
broos75126413bro_os
browner124911643browner
chronon1237353chronon
cloner84418093cloner
color76123743_color
condor94616963_condor
corner84625623corner
coroner94218203coroner
crone75231333cron_e
crones84729243crones
crony105918673cron_y
crook115217573cro_ok
croon75522783cro_on
crooner93714043crooner
croons85418423croons
croton84415453croton
crower114117553crower
crowner124012593crowner
crozer175112843crozer
cruor7310443cr_uor
dolor67617963_dolor
donors75115793_donors
door56928513_do_or
dromon939363dromon
drone65324983dron_e
droned84616863droned
droners84114383droners
drones75023433drones
drongo836793drongo
drongos935493drongos
drool65416103dro_ol
droop85814823dro_op
drover104614593drover
drowner11369803drowner
erenow937373erenow
error53712233er_ror
floor84215233flo_or
frond95316343fron_d
fronds106412343fronds
frons86124043fron_s
front85029223fron_t
fronter103611583fronter
fronton1037203fronton
fronts94415793fronts
frowner13429683frowner
goner66025153_goner
gonof95218653_gonof
grantor84010933grantor
groaner82510133groaner
grocer94212143grocer
groom85317983gro_om
groper94517253groper
grower104614933grower
honer85332093_honer
honors94816793_honors
honour94710863_honour
horror988723horror
iroko939663iroko_
irokos1037233irokos
iron46728463iron__
irone55126363iron_e
ironed74916013ironed
ironers74813543ironers
irones64724013irones
ironic8313773ironic
irons55324133iron_s
ironwork15125053ironwork
irony85015903iron_y
kaon87521023kaon__
kaonic1238763kaonic
kaons95014853kaon_s
karoo92519583karo_o_
karoos102415803karo_os
keener104012833keener
keno87926433k_eno_
kenos95220623k_enos
kimono12105413kimono_
kimonos13114633kimonos
kino86233613k_ino_
kinos96626143k_inos
klong105310403klon_g
klongs11436603klongs
kloof123812133klo_of
knar85818723k__nar
knob107417013k__nob
knop107116593k__nop
knot85630503k__not
know116115843k__now
knower1337073knower
knur85311973k__nur
kobo107422103k_obo_
kobos115616893k_obos
kolo87026223k_olo_
kolos94921213k_olos
komondor1541883komondor
konk79320613k_on_k
konks84917113k_onks
koodoo11107773koodoo
kook75822603k_o_ok
kor76538893k___or
koto86323463k_oto_
kotos95717693k_otos
kotow12528703k_otow
krater104014313krater
loner55431033_loner
manor78023923_manor
minor74920063_minor
mono66036713_mono_
monos75930863_monos
mooner85317833mooner
moor66628553_mo_or
motor75317293_motor
nor38048823___nor
odor55718093__odor
ono36838033__ono_
onos46229003__onos
orator6314533orator
pawnor11357243pawnor
phono104917023phono_
phonon114012033phonon
phonos114114793phonos
poor65630223_po_or
porno75120653porno_
pornos85015253pornos
pretor8315743pretor
prior74316173pr_ior
prober104516073prober
proctor11310433proctor
prolog94212973prolog
promo95619993promo_
promos105116423promos
pronator10311773pronator
prone75332623pron_e
prong85218113pron_g
prongs94314483prongs
pronota939763pronota
pronoun939033pronoun
pronto8313993pronto
proof105221533pro_of
proper104319953proper
proser84223463proser
proso77222413proso_
prosos85718553prosos
proton84318893proton
prover113819723prover
prowar114110943prowar
prower114218123prower
pruner83413453pruner
rancor8810373_rancor
razor143012603_razor
rigor62714053_rigor
roar46328573_ro_ar
robot7325973_robot
roger64521413_roger
rondo65218373_rondo
rondos74616723_rondos
ronion63315643_ronion
ronyon9309133_ronyon
rood56733003_ro_od
roof75738833_ro_of
rook85532033_ro_ok
room66235083_ro_om
root45655923_ro_ot
roper75431913_roper
roto45935053_roto_
rotors64917933_rotors
rotos56027883_rotos
rover85527373_rover
rower85430493_rower
rumor71011323_rumor
senor53822793_senor
signor73510353signor
sonar56523423_sonar
sooner64220463sooner
sopor74016493_sopor
sordor7310213sordor
sorner64720383sorner
spinor839943spinor
sponsor934963sponsor
spoor75016353spo_or
stoner65823203stoner
tenor53620253_tenor
toner55336243_toner
torpor839193torpor
tremor84210393tremor
trocar848763trocar
trogon73611753trogon
trona54118953tron_a
tronas63816893tronas
trone55131863tron_e
trones65629283trones
troop76417533tro_op
trooz145016153tro_oz
trover95014663trover
uropod937263uropod
vroom105312473vro_om
wrong94712323wron_g
wronger11288823wronger
wrongs10338933wrongs
zoner144520343_zoner

Search took 6 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.1401276364.3
2DLD Change Limit1127162355.50020493.8
3Display Results2352350.0802937.5
 (SQL Overall)1786912355.72031239.7
 
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.