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

220 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
krooni1039718(None) 
kroon94514481kroon_
kroons103711241kroons
croon75522782croon_
croons85418422croons
krona93611792kr_ona
krone94018732kr_one
kronor10417232kronor
aboon74918703aboon_
argon65520593argon_
argons75018203argons
ariosi64313033ariosi
aroint6328153aroint
around72712413around
aroynt9312893aroynt
arson55118833arson_
arsons63917213arsons
boon67142173_boon_
boons75031913_boons
boron76727143boron_
boronic11311163boronic
borons85520543borons
briony1149043briony
brocoli1146353brocoli
bromin102615693bromin
bronc91714343br_onc
broo65129823broo__
brooch13368443brooch
brood84620243broo_d
broods95416383broods
broody124510083broody
brook114717763broo_k
brookie1347373brookie
brooks125813883brooks
broom95022213broo_m
brooms104915873brooms
broomy13449953broomy
broos75126413broo_s
brown105619533brown_
brownie12178433brownie
browns116415633browns
browny144510043browny
bryony1435833bryony
coloni85619203coloni
coni65534803__coni
coon67248943_coon_
coons76737283_coons
corona83817403corona
croci95818133cr_oci
crone75231333cr_one
crony105918673cr_ony
crook115217573croo_k
crooks124914413crooks
crooned103813343crooned
crooner93714043crooner
crooning113112113crooning
croton84415453croton_
crotons93714373crotons
crown105620083crown_
crowns115615113crowns
cryonic1437833cryonic
dhooti1035663dhooti
dromon939363dromon_
dromond1135473dromond
dromons1038193dromons
drone65324983dr_one
drool65416103droo_l
drools74412813drools
drooly104911073drooly
droop85814823droo_p
droops95110963droops
droopy12458243droopy
drown95515823drown_
drownd11478313drownd
drowns105612333drowns
frond95316343fr_ond
frons86124043fr_ons
front85029223fr_ont
frown115415973frown_
frowns126011393frowns
goon57236173_goon_
goonie73615563_goonie
goons65326773_goons
goony95519783_goony
groan65618423groan_
groans74815063groans
groin65521083groin_
groins73917203groins
groom85317983groo_m
grooms94512523grooms
groove10438873groove
groovy13375403groovy
ground82310273ground
grown95317353grown_
groyne1037213groyne
iron46728463ir_on_
irone55126363ir_one
ironic8313773ir_onic
irons55324133ir_ons
irony85015903ir_ony
kalong1177703kalong
kaolin1039583kaolin
kaon87521023k_aon_
kaonic1238763k_aonic
kaons95014853k_aons
karoo92519583karoo__
karoos102415803karoo_s
ketone105014533ketone
ketonic1349923ketonic
kimono12105413kimono
klong105310403k_long
kloof123812133kloo_f
kloofs13386353kloofs
known12568343known_
knowns13426443knowns
koan85425033k_oan_
koans95818623k_oans
koi77534753k__o_i
koine9516483k_oine
koji155611123k__oji
konk79320613k__onk
kook75822603k_oo_k
kookie9389843k_ookie
kooks85217263k_ooks
kooky114412873k_ooky
korai97018523k_orai
korun9411923korun_
koruna1035483koruna
koruny1334443koruny
kronen10348913kronen
kroner104612573kroner
kronur10415313kronur
krubi1136523kr_ubi
loon47344793_loon_
loonie64216453_loonie
loons55731723_loons
loony86918963_loony
maroon83118203maroon_
maroons92615553maroons
moon67140813_moon_
moons75331003_moons
moony104818273_moony
moron76925423moron_
moronic11311863moronic
morons84919543morons
noon47134623_noon_
noons54125283_noons
orgone71110913orgone
orlon5415003orlon_
orlons6411013orlons
poon67341263_poon_
poons75430973_poons
poori74816233_poori
prion75119993prion_
prions84317783prions
prolong10319633prolong
prone75332623pr_one
prong85218113pr_ong
proof105221533proo_f
proofs114511683proofs
propone112716303propone
protei82615313protei
proton84318893proton_
protonic12314593protonic
protons93118003protons
rani46640113_r_ani
roan47234203_roan_
roans54926443_roans
robin74820283_robin
rood56733003_roo_d
roods65125283_roods
roof75738833_roo_f
roofie93411173_roofie
roofs85321153_roofs
rook85532033_roo_k
rookie103613263_rookie
rooks95325043_rooks
rooky126117623_rooky
room66235083_roo_m
roomie83013873_roomie
rooms75324683_rooms
roomy107118063_roomy
roose56127093_roose
roost55730933_roost
root45655923_roo_t
roots55933673_roots
rooty86423023_rooty
roshi8310753_roshi
rosin55325313_rosin
roti46332933_r_oti
round64318433_round
shoon84022013shoon_
somoni8310743somoni
soon46240503_soon_
spoon74719443spoon_
spoons84116023spoons
spoony114111793spoony
swoon85014783swoon_
swoons94511143swoons
swoony12408263swoony
toon47740633_toon_
toonie63617993_toonie
toons55027533_toons
tortoni738033tortoni
trogon73611753trogon_
trogons83410723trogons
trona54118953tr_ona
trone55131863tr_one
troop76417533troo_p
troops85712783troops
trooz145016153troo_z
tropin83316753tropin
troponin1047943troponin
twoonie1034423twoonie
vroom105312473vroo_m
vrooms11398713vrooms
wrong94712323wr_ong
yoni77524393__yoni
zoon137326983_zoon_
zoons144919693_zoons

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.376475242.0
2DLD Change Limit1127162205.29621283.2
3Display Results2202200.0762894.7
 (SQL Overall)1786912205.74831087.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.