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

203 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
carroty124894(None) 
carrot8423121carrot_
carrots9714621carrots
parroty1247861parroty
arrowy12288272_arrowy
carboy134914182carbo_y
carroch1437092carroch
carrom10513402carro_m
carroms11512402carroms
carrotin102210892carrotin
carry105823782carr__y
corrody13136142corrody
garrote8510102garrote
marrowy15236082marrowy
parrot8320662parrot_
parrots9312742parrots
argosy1036423_argosy
argot67728653_argot_
argots74116033_argots
armory114211473_armory
array86317143_arr_ay
arroba898663_arroba
arrow83414883_arro_w
arrows92813483_arrows
arroyo936963_arroyo
arty77531313_a_r_ty
barony115915303ba_rony
barratry13114473barratry
barret84930483barret_
barretry13115183barretry
barrets94917103barrets
barroom1139373barroom
barrow114512763barro_w
barrows123411683barrows
cahoot11416473cahoot_
cahoots1238473cahoots
cairny11557823cair_ny
calory11312843ca_lory
cannot83616773cannot_
canopy1337723ca_nopy
canty105226803ca__nty
capote10315733ca_pote
caprock1736813caprock
carat75048793ca_rat_
carate84734003ca_rate
carats85929023ca_rats
caraway1538133caraway
carbo94923843carbo__
carbon104919043carbo_n
carbons115418943carbons
carbonyl1595383carbonyl
carbora11310703carbora
carbos105122263carbo_s
carboxyl22103633carboxyl
carboys144711783carboys
cardon94120853cardo_n
cardons104519933cardons
cardoon104813813cardoon
caret75360563ca_ret_
carets85330773ca_rets
cargo85322073cargo__
cargoes104415223cargoes
cargos94619183cargo_s
carhop133610763carho_p
carhops14329703carhops
carioca1139683carioca
cariole9818343cariole
cariosity1446213cariosity
carious93320283carious
carload1039783carload
carnet84732873carnet_
carnets93918403carnets
carney115315703ca_rney
carnify1555883carnify
carny105822923ca_r_ny
carob95325223ca_ro_b
carobs104818103ca_robs
caroch13911763ca_roch
carol75128613ca_ro_l
caroli85918233ca_roli
carols85124983ca_rols
carom95025563ca_ro_m
caroms105619573ca_roms
carotid102014833ca_rotid
carotin92216733ca_rotin
carpet104530093carpet_
carpets113915333carpets
carpool1139223carpool
carport11316033carport
carports1238943carports
carr65434703carr___
carrack1548753carrack
carrel84718633carr_el
carrell94610473carrell
carrels95117303carrels
carried103717153carried
carrier93619583carrier
carries94328013carries
carriole1089863carriole
carrion9312673carrion
carrions10312453carrions
carritch1543483carritch
carromed1338563carromed
carrotier1146623carrotier
carrotins11239963carrotins
carrottop1342723carrottop
carrs75730853carr__s
carryon1237033carryon
carryons1337103carryons
carryout1346783carryout
carryouts1443443carryouts
cart66570343ca_r_t_
carte75940423ca_r_te
carton84522663carto_n
cartons94122473cartons
cartoon94114463cartoon
cartoony13377403cartoony
cartop104213563carto_p
carts78946293ca_r_ts
caryotin13268353caryotin
catty104520413ca__tty
cavity14310013ca_vity
cavort11316173cavort_
cavorts1237933cavorts
chariot12316213chariot_
chariots1339393chariots
charity15311023charity
charpoy1735713charpo_y
charro114212953charro__
charros124312143charro_s
charry145012113charr__y
cherty144612473cher_ty
christy1536623christy
chromy16309903c_hromy
cirrate92413493cirrate
cirrose937473cirrose
cirrous93111063cirrous
clarity12310913clarity
corody12149703c_orody
corrode101310573corrode
cowrote12289673cowrote
crafty14478913c_rafty
crony105918673c__rony
crusty114911343c_rusty
curry105920343curr__y
cursory12406393cursory
faggoty1542863faggoty
farrow12309973farro_w
farrows13259783farrows
ferrety13287013ferrety
furrowy16384473furrowy
gargety12388043gargety
garote7717953ga_rote
garret74426553garret_
garrets84413623garrets
garron73113493garro_n
garrons82713463garrons
garroted1056783garroted
garroter956573garroter
garrotes969363garrotes
garrotte965683garrotte
harlot94422803harlot_
harlotry1443403harlotry
harlots103413293harlots
harmony1538173harmony
harrow122610773harro_w
harrows132611033harrows
harry115322953harr__y
jargony1834493jargony
karroo10410013karro_o
karroos1139313karroos
maggoty1444013maggoty
marmot10318743marmot_
marmots11311513marmots
marron83717543marro_n
marrons93216973marrons
marrow112812603marro_w
marrows122911823marrows
marry104821693marr__y
narrate7313493narrate
narrow9269143narro_w
narrowly1442903narrowly
narrows10258843narrows
parity114719873pa_rity
parody12410093pa_rody
parroted1158843parroted
parroter1058203parroter
parry105323753parr__y
party106630613pa_r_ty
rarity93615493ra_rity
rooty86423023__rooty
scarcity1545093scarcity
scarry116311183scarr__y
tarot55943933ta_rot_
tarots66422993ta_rots
tarry85422513tarr__y
tarty86328183ta_r_ty
variety1337743variety
varsity1356673varsity
warranty1465043warranty
warty119323823wa_r_ty
yarrow12287933yarro_w
yarrows13277853yarrows

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272037.32618294.7
3Display Results2032030.0633222.2
 (SQL Overall)1786912037.54523683.4
 
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.